Conditional logic in a form

Xochitl Cerda

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?

Samuel Courtney

Hi @Xochitl Cerda , Smartsheet added a new workflow that allows you to change the value of a cell. I am thinking a good way to do this is to create a workflow that says if a new row is added, and the cell value is QC, then change the destination Cell to N/A.

This way, you can rely on a workflow in the sheet instead of a Formula.

Let me know if that works.

-Sam

Samuel Courtney

Hi @Xochitl Cerda , Smartsheet added a new workflow that allows you to change the value of a cell. I am thinking a good way to do this is to create a workflow that says if a new row is added, and the cell value is QC, then change the destination Cell to N/A.

This way, you can rely on a workflow in the sheet instead of a Formula.

Let me know if that works.

-Sam

Xochitl Cerda

Thanks so much @Samuel Courtney !!! Good idea. I only need to make changes in my column 'catalog responsible' since it is set as contact list, all the other 'non applicable columns' worked perfect!!

Samuel Courtney

Glad that it worked!!!