Put condition in spreadsheet column

 
1
0
-1

Hi everyone,

I want to do something like if all 'No. of Defect' column or even if one of it not equal to 0 value in 'Overall Disposition' will automatically become 'Failed'.

Thank you.


    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Do try using https://www.excelfunctions.net/excel-if-function.html .

      See Spreadsheet#SupportedFormulaFunctions for the full list of Excel like functions you can use in Spreadsheet form element.

        CommentAdd your comment...