Formulas in reports don't work

Mariachiara ✭✭
edited 04/20/21 in Formulas and Functions


I have formulas working properly in the sheets, but not in the report. For example, when a task is "Complete" in a sheet, the done checkbox is ticked and the dot gets grey; when I do the same in the report, only the status is updated.

Similarly, in the sheets a formula makes the dot yellow 15 days before the end date and red 10 days before. However, I need to open a sheet from the report for the report to be updated.

Is there a way to make these updates automatic in the report?

Thanks in advance,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!