Change value in one column based on another column

Question

Hello everyone,

I have a column that contains the values yes or no (Q4). I have another column that contains values in certain rows (Unselected Software). I want it so that if a row contains a value for Unselected Software, the value in Q4 should be changed from yes to a no.

Claje · Accepted Answer

Hi,

You can do this with a formula on your Q4 Column.

Here's an example

IF !ISEMPTY([Unselected Software]) THEN 'No' Else [Q4] ENDIF