invalid operation or #UNPARSEABLE

Options

I am trying to do a formula to determine how many days a line has been on the sheet without resolution. I tried to do this formula: =({date sent for review}@row=","Now()-{date sent for review}@row -- and am recieving a #unparseable error.


I then tried formula: =today()-{date sent for reivew}@row -- and am receiving #invalid operation.

Can I calculate the days outstanding on the report without putting today's date on the spreadsheet?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!