Hello,
I want to divide one column by another IF that column contains certain data and output the result in a new column.
Sarah 1 10
Bill 5 10
I would like to divide 1/10 if the [Name] column = "Sarah". Thank you!
Hi @insomned ,
I have created a workflow for you and in the workflow, I included two ways of doing it.
Basicly you need to write down this formula:
IF [Name]='Sarah' THEN [Column 1]/[Column 2] ELSE Null() ENDIF
First, we are checking the condition. Afterwards, we are doing calculations. If the criteria weren't met we put a null value.