Is it possible to have Sheet A populate information into Sheet B if a checkbox is checked?

Jeffrey H
Jeffrey H
edited 12/09/19 in Smartsheet Basics

Is it possible to do the following:


Sheet (A) - A checkbox is checked in Row 4

Sheet (B) - Automatically pulls in a text-field that is in Row 4


If so, how? 


The purpose is to roll all "At Risk" Description Fields into a summary sheet for the executives to review.  Reports won't work for they need to be able to type their information into corresponding fields on that same sheet (Sheet B).    


Thank you