I have created a form with conditional logic. The logic displays "catalog responsible" (column was previously set as contact list) and it is displayed only if the previous field is selected with "prod" option (column is set as dropdown)
The form works perfectly, but since other group of persons will have access to the data directly on the smartsheet, I would like to show "N/A" instead of blanks in the column "catalog responsible" when column "server" shows "QC"
I tried to add an 'if' formula: =IF(Server@row = "QC", "N/A") but if I convert to "column formula", my contact list is spoiled. Any ideas please?