Update second line based on input from first line

I have a list of inventory items. Some have a serial number, others do not. I want to be able to use a column called “Serialized” to set a Yes/No or Check/Uncheck state. If the answer is “yes” or “Checked” then I want to force the user to enter the Serial Number of that item. If it set to “no” or “Unchecked” I don’t want the user to be able to enter a serial number. Is there a way to do this?


1 Like

Hi Jason,

You can set the field as “Not empty”, and use conditional formatting to hide/display the field according to your rule so that user must enter the value when the condition is met.

Thank you. I figured out what you meant and got it to work.


1 Like