Automation: Copy cell value to another sheet

Hi, not sure whether this has been answered yet but my question is as follows:

I have a sheet, Sheet A, that stores all the projects and their information, such as Project ID, project status.

I have another sheet, Sheet B, that stores only projects that have reached a certain stage (ex. in execution).

And I just want to know if it is possible to automate copying JUST the Project ID from Sheet A over to Sheet B when it has reached the execution stage. I have tried formulas and automation but automation can only copy the entire row, when I only need the Project IDs. Also, both Sheet A and Sheet B have a different structure, hence copying the entire row would not work for me.

Would appreciate any help or suggestion with this, thanks!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!