get cell value from one sheet to another based on ID column

Options
Mashael
Mashael ✭✭
edited 07/19/23 in Smartsheet Basics

I have three grid sheets A,B,C


in sheet, A I have two columns as follows:

in sheet B& C, I have the same two columns.


I want sheet B to get the status value if the status changes in C

Also, I want sheet A to get the status value if the status changes in B


is it possible to achieve this using Vlookup or any other method?

Please note that I tried using automation to copy records if the status changes, but that will create a new row in my sheet. I don't want duplicates ID. I just need to update the status of the sheets whenever there is a change made based on the ID column


Kindly advise. Thank you!

Tags:

Answers