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:
Hi,
I would like to update the 'Status' Column to CLOSED when the 'Done' checkbox is CHECKED.
Hi Ashanth,
Try something like this.
Be aware that if you change the status manually, it will delete the formula, so you need to add conditions for the different statuses if you want to keep the formula.
=IF(Done@row = 1; "CLOSED")
The same version but with the below changes for your and others convenience.
=IF(Done@row = 1, "CLOSED")
Depending on your country, you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hi Andree,
Thank you for the solution! It does work but the Status Column that is being affected is restricted to only dropdown options. And I need that column to be switch to "CLOSED" from whatever status it is currently in when 'Done' is CHECKED. Example; Status for one row can be in "REVIEW", but once i check the 'Done' box, the respective Status should change from "REVIEW" to "COMPLETE".
Andree alluded to this in his first statement, but if you automate one part of a dropdown you need to automate ALL of the dropdown states. The formula has to go in the place you want the results. Whenever anyone manually changes the dropdown status, your formula will be overwritten. So you will need to automate all of the other stages. I've seen this done by using checkboxes for each stage, or date input fields for the completion date of different stages.
Happy to help!
You'll have to either have a part in the formula for each status or use a third-party service, like Zapier. Is that an option?
Yes you guys are right! It worked
Thank you to both of you!
You're welcome. I'm happy to be of assistance.
Excellent!
Hey Andree and/or Mike,
Follow up to "adding conditions for the different statuses if you want to keep the formula."
Can you advise how that is spelled out?
I have a team member who would like to use a column of "Daily To Do" to assign days to tasks. If they are in card view and move something from "Thursday" to "DONE" we would like to automate it more fully to also check the "Done" box and vice versa, if they are in grid view and check "Done" we would like the "Daily To Do" column to be "DONE".
The "Daily To Do" options are: Monday, Tuesday, Wednesday, Thursday, Friday, DONE, To Schedule.
@Torie Hollingsworth
Hi Torie,
The third-party service, Zapier, is an excellent option for this scenario. Is that an option for you?
Would that work?
Have a fantastic week!
✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…
