Using toNumber

Number must be at the start of the Frequency options.

Entries

Next Date

dateAdd(prop("Last Completed"), toNumber(prop("Frequency")), "days")

Using replaceAll

Number can be anywhere in Frequency option.

Entries

Next Date

dateAdd(prop("Last Completed"), toNumber(replaceAll(prop("Frequency"), "[^0-9.]", "")), "days")

Using Nested if

Formula would need to be updated if you added a new Frequency option.

Entries

Next Date

if(prop("Frequency") == "Weekly", dateAdd(prop("Last Completed"), 1, "weeks"), if(prop("Frequency") == "Fortnightly", dateAdd(prop("Last Completed"), 2, "weeks"), if(prop("Frequency") == "Monthly", dateAdd(prop("Last Completed"), 1, "months"), fromTimestamp(toNumber("")))))

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>