Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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.
Hi there, I have just recently worked with Smartsheet's Implementation team to build a Control Center Blueprint. The workspace that holds the solution is titled something very generic and I would like to rename it. Can I do that w/out breaking anything or what steps would I need to take to successfully rename it. Thanks in…
Hey, I've got a sheet, which is autopopulated as a source sheet to feed into DataMesh (which runs once every 24 hours). Once DataMesh has run, how can I auto-clear the rows in the sheet to avoid repeating this the next day? I have no use to keep the data and want to avoid clogging up the source sheet. I have tried…
Hello everyone seeking for an answer and help please im having a hard time on approval request automation . My workflow runs smoothly however when the approver open the attachment on the request it automatically downloads and when clicking the approve it says link are already used and auto decline teh approval request…
