Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Duration as a report filter


I'm trying to set up a report of my to-dos that have a duration of 5m or less but am having trouble setting up a duration filter based on anything other than whole days. I know I could probably create a custom column  in every sheet with a checkbox to say the task takes 5 min. or less or a formula converting the duration field in to a set number, but I've got a lot of sheets that already overwhelm some of my users and I'd rather not add yet another column to the mix.


Has anyone been able to successfully create a report along these lines?





This discussion has been closed.