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!😀
Answers
-
Try this...
=IF([CEPA/EPA complete date]@row <> "", [CEPA/EPA complete date]@row, TODAY()) - [Approval Date]@row
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
It worked! Thank you so much.
So I can learn to do this independently next time, how does this work? I think it says if the complete date is something other than blank then use the CEPA/EPA complete date, otherwise use today - approval.
-
Happy to help. 👍️
And yes. That is exactly what the formula is saying.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!