Conditionally changing cells

Scott Rae

Hi,

I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value.

I know that the changed to functionality is available through automation, however the action options in automation do not offer cell changing functionality.

If this is unclear please feel free to ask me to elaborate.

Cheers

Nasir@EBC

Hi

At present there is no such option / workflow that would auto-change a cell's value, based on another one.

I hope this feature is added soon!

Best...

Andrée Starå

Hi @Scott Rae,

If you don't need to change the value in the cell, it will work with an IF function formula.

Would that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Scott Rae

Hi @Andrée Starå

The problem with using an IF statement would be that I want the dependant cell to remain what it was set as even if the main cell then goes on to be changed.

From what I understand there is no rule within an IF statement for this

Thanks for your reply,

Regards,

Scott

Andrée Starå

@Scott Rae

Happy to help!

The third-party service, Zapier, is an excellent option for this scenario. Is that an option for you?

Scott Rae

@Andrée Starå

Thanks,

I'll look into this

Andrée Starå

Happy to help!

Let me know if you need any additional help!

✅Please help the Community by marking the post(s) that helped answer your question or solve your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Eduardo Vivas

This worked for me

=IF([Column Name]@row = "String Value", "String Value")

Andrée Starå

@Scott Rae

Please have a look at my post below, where I describe a method that might help with your use-case.

Lock or Store Date/Value Solution without using Zapier

Andrée Starå

May 24, 2020

Hi all,

I hope you're well and safe!

I've developed a solution that lets you store the date or value.

You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work.

We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id/value that we can use, it will work.

Also, this opens up more options with auto-numbering and similar.

Depending on other workflows, you could reuse one sheet for multiple workflows.

I hope that helps!

Let me know if you have any questions!

Stay safe and have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

---

View Post

Let me know how it goes!

Peter Luethi

Dear @Andrée Starå

I'm working on an Action Item sheet which collects action items with action, owners, due dates, and status (New/Open, In Progress, Overdue, Completed, Unassigned).

I want this list to be supported by automated workflows, which notifies owners when items turn overdue based on the due date (due date + 1 day @ 06:00 triggers email). This is implemented and works.

Now I also want to change the status automatically BY the workflow (i.e. cell content set to Overdue). I don't want to program the sheet cells itself, but the workflow shall modify the content of the sheet (i.e. the status field). I don't want to program the cells because this is "user space" with manual entry/drop-down of the status. (And I don't want to duplicate status columns as computed columns, which then compute user input & dates to overall status.) The workflow itself shall act as a "governance user" to support the overall action item process (sending emails, updating fields, etc.). No programming stuff & hidden logic wanted in the sheet.

At the moment I don't see a lean way of implementing this with your workflows - whilst refraining from cell formulas. An awkward experiment could be to copy content (the string "Overdue") from other sheets into the action item sheet. I'm looking for a workflow capability to directly modify cell content in the sheet.

Dou you have an idea or future Smartsheet Workflow feature to accomplish this intent?

Shall I submit a product enhancement request?

with best regards,

Peter

Andrée Starå

Hi @Peter Luethi

Yes, Please submit an Enhancement Request when you have a moment

The third-party service, Zapier, is an excellent option for this scenario.

Is that an option for you?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) 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!

A Rose

Change Cell Value Autmation is now a built in solution!