Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Nested Formulas issue
I am currently working on moving some trackers into sheets from excel and I have hit a roadblock with the following formula which works in excel. I have looked at the template formula sheet and I can get them individually to work however not together. Thank you in advance for any help.
I forgot to mention that currently I can get them working separately but not together with the formulas below. I ended up using ISBLANK because was the only way I saw progress. The cell the result is expected is formatted to text/number and the other two are in date format.
=IF(ISBLANK([Date Completed]9), "", "Task Complete")
=IF(ISBLANK([Target Date]10), "", ([Target Date]10 - [Target Date]1))