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?

Find more posts tagged with

Formulas

Reports

Dashboards

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.