Skip to main content

Hello there


For recurring tasks, I’d like to calculate the data depending on what I select in the single select field. For example:


if “2 weeks” choose the formula which adds 2 weeks to a date or if “1 month” then add 1 month and so on.


Is that possible?


Thank you.


Cheers


Marc

I figured it out. I’ll add more IF statements as needed:


DATETIME_FORMAT(IF(Interval = “2 weeks”, DATEADD(Auftragsdatum, 2, “week”),IF(Interval = “1 month”, DATEADD(Auftragsdatum, 1, “month”), “”)), “D.M.YYYY”)

Terms & Conditions