Add row data to a separate sheet ONLY if a box is checked

kapears76161 ✭✭✭
edited 12/09/19 in Formulas and Functions

Ok. After 1.5 hours of trying to figure this out myself, I am reaching out to the experts.

I have multiple Smartsheet Forms feeding into one Master Data Sheet. Each row of incoming data is then assessed for approval based on certain cell criteria, and if approved I check a box in the "Approval" column (image belwo). Based on this action, and a condition of which Donation Type (image below) box is checked, I want a few cells within the approved row to link over to a separate sheet for task tracking.

Is this possible? If so, I need formula help too.

Thank you!

Approval Column.PNG

Donation Type.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!