Combining two IF functions

Hello!

I am trying to make is a formula that says "If there is a complete date then calculate the # of days that that task took from approval to completion. If complete date is blank then calculate how many days has passed since the approval date".

I have two formulas that work independently but I can't figure out how to put them together. I think I need to make this an OR statement but all my iterations don't seem to work. Any advise would be greatly appreciated.

Formula 1:

IF(ISDATE([CEPA/EPA complete date]@row), [CEPA/EPA complete date]@row - [Approval Date]@row

Formula 2:

=IF(ISBLANK([CEPA/EPA complete date]@row), TODAY() - [Approval Date]@row)


Thank you!😀

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!