Help

Formula combining Help

Topic Labels: Formulas
916 2
cancel
Showing results for 
Search instead for 
Did you mean: 
LP321
4 - Data Explorer
4 - Data Explorer

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
dilipborad
9 - Sun
9 - Sun

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.

LP321
4 - Data Explorer
4 - Data Explorer

This worked perfectly. Thanks!