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?