Copy few cells from 1 sheet to another based on a filter

Agamdeep

I have a sheet named "T1 SQDVP", and I want to copy the "Safety Details" data from this sheet into the "Action Log" sheet, creating a new action under the "Follow Up Action" column.

Based on the filter when Column "Safety Action / Escalation" is selected as "Action Required at Tier 1"

See screenshots. Any suggestions would be highly appreciated. I tried using the Copy row automation but I will copy the entire row instead of selected columns.

SQDVP Sheet.jpg

Action Log.jpg

kowal

hi @Agamdeep,

You can either copy / move the entire row from one sheet to another or you can cell link those cells.

There is no other way.

Andrée Starå

https://community.smartsheet.com/discussion/140206/copy-few-cells-from-1-sheet-to-another-based-on-a-filter

Hi,

I hope you're well and safe!

1️⃣ You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

2️⃣ Another option would be to use so-called helper sheets. In short, copy the row to a helper sheet, use my previous method to get the values you need to another helper sheet, and then copy/move the row from that sheet to the main destination sheet.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏