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
-
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/
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!