Sign in to join the conversation:
I am trying to figure out a formula that when I change the value of the %complete to %100 my status column with drop down list pics a specific word and fills it in the cell. Can this be done?
Hi Octavio,
Yes, it can. Use the formula below in the status column.
=IF([%Complete]@row = 1; "Complete")
Depending on your country you’ll need to exchange the semi-colon to a comma in the above formula.
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
One thing you have to consider when using a formula in a drop-down box is that if you are using reports to have people update and monitor their tasks they won't be able to change the dropdown in their report. Fields with formulas are not editable in reports. That's the only drawback.
Greetings- I have a drop-down column where a staff member is emailed (request an update) if a row is marked as "assigned". If row 1,2,3 are assigned to the same staff member within a few mins, that staff member receives 1 email rather than 3 separate emails. We want each row to be a separate email so they can mark that row…
All of the automation workflows on all our sheets are "missing". This is what we see when we click "manage automation workflows" We're also unable to create new workflow. Smartsheet Gov Status shows no issues with workflows. Is anyone else experiencing this issue?
Hi. I have been the System Admin for the past 2 years. When I came into this role, I added our logo under the setting in Branding & Personalization. Our logo has now changed and I need to update it. However, when I go to Branding & Personalization the only options I have are Profile Visibility and Working Days. Did…
