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:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!