Using Control Center to pull data from an intake sheet into an editable report?
I have an intake sheet fed by a form which then triggers control center to run and extract the data from that intake sheet and create a new workspace for each entry. I need to present the data from the intake as a part of the dashboard, currently i am using reports on a dashboard and visually it works. However, we cannot figure out how to make the data editable at that point. I've tried One Time Write in the blueprint, but I still get the error that the cell is updated via an inbound link and cannot be edited. I've also tried Editable Value, same outcome.
Is there a way to take the date entered in the form which feeds the intake sheet, and make it locally editable within the workspace?
Thanks!
Best Answer
-
Thank you, Matt., I'm beginning to think my blueprint itself had some issues, as once I deleted it and started a fresh one, I was able to use "editable value" and it worked as intended.
These were all text fields or drop-down selections, no dates.
Thank you for your comment tho, I didn't think about the autogenerated dates, yea it makes sense that would not be editable.
Cheers!
Answers
-
Hi @MOC
Is the date field a system generated field or manually entered into the form? If its a "Date Created" auto field, then its not editable. If its manually entered into the form, then it should be editable on a report coming off the intake sheet. Is the date field "Profile Data" that's being pushed from the projects back into the Intake? Maybe if you could share some screen shots that might help too.
Thanks,
Matt
-
Thank you, Matt., I'm beginning to think my blueprint itself had some issues, as once I deleted it and started a fresh one, I was able to use "editable value" and it worked as intended.
These were all text fields or drop-down selections, no dates.
Thank you for your comment tho, I didn't think about the autogenerated dates, yea it makes sense that would not be editable.
Cheers!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives