Add row data to a separate sheet ONLY if a box is checked
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.
Help Article Resources
Check out the Formula Handbook template!