Updating a cell value in a Smartsheet based on change with another Smartsheet



I have two smartsheets. And there is an automation defined between them. Whenever Status column changed to "Scheduled", it triggers workflow and related row/rows copied to another Smartsheet. In the target Smartsheet, there are also some manual entries. This works fine. I have another need. Now if Status column changed to "Completed" in the source Smartsheet I want to update some metrics for that specific row in source Smartsheet to Target Smartsheet. To do that, I tried to use VLOOKUP, but in that situation, it pulls data only from source Smartsheet, in case there is no match I would like to enter the cell value manually but Smartsheet doesn't allow it. I can only choose a default value in case of NO MATCH.

What would be the best approach to overcome this issue? Looking forward to hearing from you!

Best regards,


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @salimtutuncu

    I hope you're well and safe!

    Here's a possible workaround or workarounds

    • Add a so-called helper column where you can input a value manually and update the formula used so that if it isn't empty, it will show that value instead.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • salimtutuncu

    Hi Andree,

    Thanks, it solved the issue. I have one more question. I would like to allow data entry to a specific column only when status column value changed to "Scheduled". Is there a way to add conditional warning message? I know we have conditional formatting but it only helps to change format.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!