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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!