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

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…