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?
Thanks!
Comments
-
This formula should do it.
=IF(Duration1 < 0.01043, "Less than 5 min", "Greater than 5 min")
-
Great suggestion, Brett! You could "hide" the column, Elenka, which will keep it from being visible to your users and making your sheet overwhelming
