How can I use one sheet to build onto another and still be able to manipulate the data?
I am pretty new to Smartsheet, and my office would like to account for requests using Smartsheet. There are two types of requests: Original and Supplemental. Supplemental requests build onto original requests. Therefore, if someone wants to request the same individual, they will submit a supplemental request because an original already exists. I thought it best to create two separate sheets and forms for original and supplemental requests and bring them in together into a report, but I cannot manipulate report data. If anyone has advice on how to better go about solving this, please assist.
My next hurdle is figuring out how to automatically send each request based on budget threshold to two different groups of people.
Answers
-
Id build it into one sheet with a type column indicating Original and Supplemental. You can make 2 forms on that sheet for each type and by clicking the link in can populate the type. You can manage the data via the sheet or a report. Also, you cant change data on a report if the cell has a formula.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives