Help

Change date - depending on single select

Topic Labels: Formulas
Solved
Jump to Solution
1611 1
cancel
Showing results for 
Search instead for 
Did you mean: 
mycale
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
mycale
5 - Automation Enthusiast
5 - Automation Enthusiast

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”)

See Solution in Thread

1 Reply 1
mycale
5 - Automation Enthusiast
5 - Automation Enthusiast

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”)