Best Practice - Data Integrity - Forms

When your business starts to build lots of sheets (as we have) the issue of data integrity comes into play. That is if you have lots sheets with names, or activities you can now put them into one sheet and reference to them BUT whenever you build a form and want to restrict the user selection to the defaults in the drop down list, these have to be are entered at the column level and cannot reference your master reference.

Tell me if I am wrong!. This needs to be resolved to ensure there is not madness in updating multiple forms selections manually across multiple sheets.....

Then IF you could actually refer to a column(s) of master data in a form AND you could then reference an EXISTING row to perform an update on it (from a FORM or a update request) we would be in a great place.

Any ideas out there, is this on the never never enhancement list ?

Find more posts tagged with

Forms

Sales

Manufacturing

Sheets

Finance

Sharing and Collaboration

Solution Center

Project Management

Update Requests

Enhancement Request

Comments

Shaine Greenwood

Hello,

You're correct in that Smartsheet doesn't have a concept of a "master dropdown list" or "master column settings" type of feature by default.

If you're looking for that form of control over your implementation, I'd recommend checking out our Control Center premium app. This app gives you the ability to deploy at scale: https://www.smartsheet.com/product/control-center

k.mcnamara23941

I looked at control center link and it doesnt say much. Can it do what I am requesting or is this just an upsell.

I have used lots of form apps, having drop down lists data external to the form is a common feature.

All you need is to define a range (which you can do already) and associate it to the form.

Ken

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…