Required advice on creating a view on Overdue tasks

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?

Answers

  • Itai Perez
    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.

    Itai Perez

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

  • Sonnie
    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. 😀

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!