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.
-
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.π
