
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 08, 2023 02:01 AM
Hello, I'm trying to return the date in a field based on the urgency selected in another field. For example, if the urgency is "As soon as possible" the date should return today's date which I'm able to get with TODAY() formula. However, I couldn't manage to get next week's date with TODAY() + 7 as I would do in Excel. What is the correct formula would be for that? Thank you!
Solved! Go to Solution.
Reply
1 Solution
Accepted Solutions

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 08, 2023 07:15 AM
Hello. This should work:
IF(urgency="As soon as possible",TODAY(),DATEADD(TODAY(),7,'days'))
Reply
1 Reply 1

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 08, 2023 07:15 AM
Hello. This should work:
IF(urgency="As soon as possible",TODAY(),DATEADD(TODAY(),7,'days'))
Reply
