
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 08, 2019 04:49 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 08, 2019 07:08 AM
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”)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 08, 2019 07:08 AM
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”)
