Using Control Center to pull data from an intake sheet into an editable report?

MOC
MOC ✭✭✭
edited 09/25/23 in Add Ons and Integrations

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

  • MOC
    MOC ✭✭✭
    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

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭

    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

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

  • MOC
    MOC ✭✭✭
    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!