How can I get specific information once its put into my base sheet, into multiple other sheets?
I have a request sheet that people will be submitting information into. Based on that information, I want one core column to be cross referenced into other sheets.
Essentially that column will just be a task number, 001, 002, etc..
Once someone submits a something into that sheet that gets auto populated with the task number, I need that task number to get sent to other sheets based on the information the submitter put in.
And in the other sheets that use that task number for reference, once they check a box I want to have it reference the first request sheet and also make it so that row is crossed out/checked complete
Tags:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!