Formula Help

I am trying to fix a formula. What I am trying to achieve is the number of days between the Assigned Date and the Created Date. The "Executed" is for when the status changes to Executed. I have a status column and date columns following for the statuses like "Assigned" , "Pending" etc. and for each status is a date column that is auto populated.

=IF([Created] = "", TODAY() - [Assigned Date]@row, "Executed") -this is coming up #unparseable

(I don't quite understand the formula above, but it was left by another staff person and I need to fix it)

If I can get it to work right, it would have a number in that column until it becomes "Executed" I hope it all makes sense.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!