Automated Single Cell Information

Options

I am trying to create an automated workflow so that if cell 2B gets added or updated, then it updates only the cell in 2C, not the whole C column.

Best Answer

  • Scott Orsey
    Scott Orsey ✭✭✭✭✭
    Answer ✓
    Options

    Hi @Heald33, I'm sorry. You may need to give us a little more information so we can be helpful. Could you maybe add a screenshot of your automation?

    Automations are performed on each row individually. So if every row in your sheet is getting updated, then the conditions within the automation are being met for every row. I'd look at the conditions you've set to trigger the workflow.

    The bottom line is that the functionality that you want is exactly how SS automations are designed to work.

    I hope this helps. Be well!

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

Answers

  • Scott Orsey
    Scott Orsey ✭✭✭✭✭
    Answer ✓
    Options

    Hi @Heald33, I'm sorry. You may need to give us a little more information so we can be helpful. Could you maybe add a screenshot of your automation?

    Automations are performed on each row individually. So if every row in your sheet is getting updated, then the conditions within the automation are being met for every row. I'd look at the conditions you've set to trigger the workflow.

    The bottom line is that the functionality that you want is exactly how SS automations are designed to work.

    I hope this helps. Be well!

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!