Make a Column Required

Angela Hill CC

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?

Jason Tarpinian

If your users are adding records via a form, you can require a field in the field settings.

1. Add the field to the form.
2. Select the field.
3. Toggle the "Required" button

If they are adding records directly in the sheet, you won't be able to control it.

Angela Hill CC

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