Conditional logic in a form

Xochitl Cerda
Xochitl Cerda ✭✭✭✭
edited 08/28/21 in Smartsheet Basics

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?


Best Answer

  • Samuel Courtney
    Answer ✓

    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.