Automate duration values based on a particular selection made in a form

I'd like to automate timings put into the duration column (shorter than days, e.g. 3 hours, etc.) based on selections made in a form submission to a sheet. Alternatively, setting up an automated workflow in the sheet that will automate timings in the duration column. again based on a particular selection being made.

Sign in to vote!

Find more posts tagged with

Idea Submitted

Product Development

Project Management

Workflows in Smartsheet

Comments

Brewso

Hello Grace, Have you found a solution? I have the same need where depending on the staus of a task, if I make it not applicable, I would like the duration to be adjusted to 0d, please let me know! Thanking you in advance!

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.