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

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,

Find more posts tagged with

Accepted answers

All comments

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,

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.