Skip to main content

Hi everyone,

I'm having trouble with this formula. Can you tell me what I'm missing?

It comes up blank.

Thank you!

SWITCH({Recurring Frequency},"daily", DATEADD({Date to work on it}, 1,'days'),"weekly", DATEADD({Date to work on it}, 1,'weeks'),"monthly", DATEADD({Date to work on it}, 1,'months'),"quarterly", DATEADD({Date to work on it}, 3,'months'))

 

I would check that the capitalization is the same between your SWITCH expressions and what's in your {Recurring Frequency} field.

Reply


Terms & Conditions