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

Options

Hello,

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,

Answers

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

    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!

    Best,

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    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
    Options

    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.


    Thanks,

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!