Is there a way to change info in a master sheet to be reflected in sub sheets?

Options

Hi all!

New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Sheet" where all of the registrations flow into. I have created "sub" sheets, and created work flows that will feed and copy the rows based on class type (ie Science). The work flow works great and feeds into the sub sheets but my problem is that when I change information in a row on the masterlist, click save, it doesn't show the change in the respective sheet.

Example: I am going through the masterlist to verify student information, and I notice a spelling error in "Johnny's" name. So Infound that if I just click on the box and change the information, save, the change is reflected in the master list, but when I go to the sub sheet where Johnny's information was automated into, nothing has changed. One method I found that works (but is tedious and creates double the work), is that in the mastersheet, I will completely delete one box under the "class type" column (ie. Science), press save, change the desired information that is incorrect (spelling of Johnny's name) and then paste back the "Science" then click save, then go to the Science sub sheet and click refresh, it'll populate a NEW entry with the information I changed, and not "edit" the existing row that was already there. So then I keep the new row with the updated information and delete the row that didn't change. This is tedious as I basically have to check every single one to see if it copied into the sub sheet.

Long question short, is there a way to change information in a row in the Mastersheet, to be reflected in the "sub" sheets that it feeds into? Is there a special way to change or save I'm missing?

Thank you SO much in advance for your help! Only been using Smartsheet for about a month and still learning the ways.

  • Alex


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!