Require column data for new item row entry in datasheets
As a Smartsheet admin and owner of the project workspaces for my organization; why can't I enforce data entry for certain columns before a new row entry is allowed to be saved?
I can toggle this setting in SharePoint lists. And please don't say send them to a form. The users know how to get to the datasheets and they're going to go there to enter new items. The datasheets end up being a mess of inconsistent rows items and it's impossible to report or chart items accurately due to this.
Answers
-
Put the sheet in a workspace they do not have access to, then send them to forms :)
You can setup a helper sheet for deleting rows and add an automation that sends a notification that it should have had completed fields and is being removed, then move the row to the helper sheet. Not very friendly, but effective.
You can add "Update Request" automations when row is added with missing field(s) to ask for fields to be completed (can keep sending this daily until they fix it). More friendly, less effective.
Hope this helps!
