Days to Complete Formula for Specific Criteria
Hello all!
I am struggling with a formula for 'Days to Complete'. I have a sheet from a template that previously had this formula for days to complete:
=IF([% Complete]@row < 1, "N/A", [Actual Delivery Date]@row - [Date Requested]@row)
The sheet has been updated and customized and the [% Complete] is no longer relevant for the formula. This new sheet only includes completed work moved from an active sheet. I need to determine this formula for days to complete now based on the column [Campaign or Project Required] not being blank. I've looked up formulas relating to not blank for the first portion of the formula but am having trouble. I appreciate any advice.
Thank you!
Best Answer
-
So I believe you're looking for
if([Campaign or Project Required]@row <>"",[Actual Delivery Date]@row - [Date Requested]@row)
Answers
-
For not equaling blank you can use something like if([Campaign or Project Required]@row <>"","Do this","Do that")
-
So I believe you're looking for
if([Campaign or Project Required]@row <>"",[Actual Delivery Date]@row - [Date Requested]@row)
-
@Michael Culley Thanks so much! I had to add a few spaces and it worked perfectly! Much appreciated.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!