Conditionally changing cells

Conditionally changing cells

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

Answers

  • 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åAndrée Starå ✭✭✭✭✭
    edited 01/31/20

    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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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å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?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 02/04/20

    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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • This worked for me

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

  • Andrée Starå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.


    Let me know how it goes!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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å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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.