EricFixler
7 years agoQrew Member
Formula Duration in a nested if statement
I have a formula that calculates the duration if the checkbox is checked.
If([Appraisal Received]=true, (ToDays(([Appraisal Due Date]-[Appraisal Received Date]))))
I am trying to run a nested if statement that will output " ON TIME" is the result is <=0, or display the calculated duration past the due date in a red background with white letters.
Thank you,
If([Appraisal Received]=true, (ToDays(([Appraisal Due Date]-[Appraisal Received Date]))))
I am trying to run a nested if statement that will output " ON TIME" is the result is <=0, or display the calculated duration past the due date in a red background with white letters.
Thank you,