Transfer specific row data to another sheet when a checkbox or drop down menu item chosen.

gwilkinson
gwilkinson ✭✭
edited 08/20/24 in Smartsheet Basics

In short, I would like to have a menu item or checkbox in one form that when checked it sends certain specific cells on said sheet to another sheet.

Can I tackle this with an automation?

Answers

  • Matt Lynn-PCG
    Matt Lynn-PCG ✭✭✭✭✭✭

    @gwilkinson You can copy/move an entire row. If you're only wanting some info from that row on another sheet, you'd have to put a formula on that destination sheet to look for said value, if the checkbox at that row was checked. Something like a index(collect()). Not sure that's what you're looking for though?

    Certified Platinum Partner

    PrimeConsulting.com