Can you force/require a user to enter information into all fields?

Jessica King

I am working on a tracker in Smartsheet, which requires a large number of individuals to enter multiple rows/columns of information. That being said, I'd like to "control" the integrity of the tracker to some degree. Is there any way to "force" or "require" a user populate all columns, if data is entered into one column? For example, if someone enters Client Name in column A, they have to enter Client Manager into column B, # of Sales in column C, Annual Revenue in column D before proceeding/saving/moving to the next row. Hopefully this makes sense.

Alison

The only way to do this would likely be with Forms (meaning, you can require all fields to be filled in before submission on a Form), but there isn't the feature of Logic in Forms, so answering column A would not be able to force you to answer column B. However, feel free to put in a Product Enhancement Request under "Additional Resources" on the bottom right-hand side of the Community page.

Forms:

https://help.smartsheet.com/articles/522221-collect-information-form

Jessica King

With Forms, can you then edit said for entry? For example, if Client A's sales # was entered erroneously?

Jessica King

Also - I believe this could be done in an Excel macro....could this be adapted into Smartsheet? Sorry if it's a silly question - very new to Smartsheet. Thank you!

Andrée Starå

Hi Jessica,

@Jessica King

A possible workaround could be to use an automated update request to send out if the user didn’t fill in all fields, and it could be combined to show help texts or colors what to fill in, what is left or similar.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!