Auto populate from one sheet into blank rows on another

edited 12/09/19 in Formulas and Functions

Hi All!

I searched for this, but couldn't find an answer.  Maybe it doesn't exist!

I'm trying to set up a new dashboard for sales reps.  In one sheet I will have them fill out all of their activities.  I was TRYING to get them to fill out all information on one sheet to keep things simple for them.  Is there a way for me to set it up so that when they fill out customer contact information, that  info automatically populates into a new spreadsheet that we have just for contacts? 

Maybe this is too much for a spreadsheet.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!