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

salimtutuncu

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,

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!

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!

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.

Thanks,