Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2024 10:41 AM
Formula for 1st Column:
IF(IS_AFTER(TODAY(), {MOC Requested}), DATETIME_DIFF(TODAY(), {MOC Requested}, 'days'))
Formula for 2nd Column:
IF(IS_AFTER(TODAY(), {MOC Requested}), DATETIME_DIFF({MOC Submitted Date (from Memo of Correction)}, {MOC Requested}, 'days'))
What I would like to have is a formula (preferably in 1 column) that calculates the number of days between the 3rd column and today unless a date has been entered into the 4th column. Then I want it to show the number of days between column 3 and column 4.
I can't find a way to combine my 2 formulas
2 Replies 2
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2024 09:18 PM - edited Jan 22, 2024 09:33 AM
Hello @LP321
Use this and change field names accordingly.
IF({MOC Submitted},IF(IS_AFTER(TODAY(), {MOC Requested}), DATETIME_DIFF({MOC Submitted}, {MOC Requested}, 'days')),IF(IS_AFTER(TODAY(), {MOC Requested}), DATETIME_DIFF(TODAY(), {MOC Requested}, 'days')))
I hope this helps 👍
If it's helps then mark it as a solution.
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 22, 2024 08:11 AM
This worked perfectly. Thanks!
