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

  • Jason Tarpinian
    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.

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

  • Angela Hill CC
    edited 09/11/24

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