Make a Column Required
I have a sheet that has a formula that will show as invalid operation until another column has had data added. Is there a way to require a column be completed? You can see below that the user didn't fill out a start date on row 1, so a job number can't be created because the formula is dependent on that data:
=[CUSTOMER NUMBER]@row + "-" + RIGHT(YEAR([START DATE]@row), 2) + RIGHT("00" + COUNTIFS([START DATE]:[START DATE], IFERROR(YEAR(@cell ), 0) = YEAR([START DATE]@row), Row:Row, @cell <= Row@row), 3)
So I need to force users to complete that column, but "make column required" is not an option. Any suggestions?
Answers
-
If your users are adding records via a form, you can require a field in the field settings.
- Add the field to the form.
- Select the field.
- Toggle the "Required" button
If they are adding records directly in the sheet, you won't be able to control it.
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Yeah, I saw that and have already created a form. My guys will prefer to use the sheet, I'm afraid. I created a conditional format that turns it red if it isn't filled out by a certain point, but that is not a real answer. I see it has been asked that column management be enforced to no avail with the SmartSheet gods.🙄
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives