Formula don't work in reports
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
Check out the Formula Handbook template!