Formulas in reports don't work

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

Hello,

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,

Mariachiara

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!