Sheet Connection
scope: I have several states working and adding every day into smartsheet sheets, those sheets are required to be seen / reviewed by the state managers, out of this information I want to create a daily updated sheet from this on a master sheet for CEO level.
Client requirement: to see an overall update daily with the new added lines and a dashboard, the dashboard is all done - but how do I get the daily added lines into the master sheet.
Answers
-
@Sarah Schmitz One way I can think of is creating a column (say 'Created on') with type Auto Number/System and selecting Created (Date) option. This will at least give you the date each row is added. Then on the master sheet, you can import those rows by checking them against TODAY() function. If you can create a report that'd be easy I feel. The report's 'what' will have all the state level sheets, 'when' will be 'Created on' column with today settings.
Hope this helps.
-
Thanks @Ameyaa, I am trying a report I think that is the best, I figured I just set a date range and use "where" and "when" and leave the "who" and "what" function blank, so far it works, I will use this as master sheet, but will base my calculations out of the sheets per state to create my dashboard. I hope that works.
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
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives