Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Change date - depending on single select

Topic Labels: Formulas
Solved
Jump to Solution
1783 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”)