Required advice on creating a view on Overdue tasks

Sonnie

Hi, Smartsheet champions.

Does anybody have ideas on creating a view like below (or similar) on Overdue tasks?

Perhaps creating a column in tasks sheet with formulas to calculate the Days Ago number and pulling a report will work?

Itai Perez

Hi @Sonnie

Sounds like your idea is a good idea. Create a column with the days ago calculation (You can create another one with an IF formula that will show it in the format you like with the wording) than create a report from it and filter the report to only show these tasks.

Sonnie

Thanks Itai.

I was able to get this done.

However, I am not able to get the line break between the number and "Days Ago"; however, it is not a major issue for me. 😀