Resource Master Sheet

mallen101

mallen101 ✭✭

07/21/22 in Smartsheet Basics

Hi All,

I hope I can legibly explain what I need here :)

I would like to create a master sheet that will summarise what resources including dates/tasks I have assigned in other sheets.

Is this possible to grab this info automatically from multiple sheets and also automate updates when changes are made?

Cheers in advanced.

Tags:

Automations

0 ·

Answers

Amit Wadhwani ✭✭✭✭✭✭

07/21/22

Hi @mallen101
Would a report not do this job for you?
Thanks
Amit
https://www.linkedin.com/in/amitinddr/

Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA

Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Dashboard Metric Widget Not Updating with Current Backend Sheet Value
Hi all, This is from a sheet that uses a formula to count down / display the number of days til end of Quarter. What is happening: Displays 37 when the backend sheet actually says 34. The dashboard does not update until I click to open the backend sheet then the connection seems to go through to update the…
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…

Help shape the future of Smartsheet.
Share your ideas and feature requests.