Change value in one column based on another column

[Chirag_Gandhi07]

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 solution]

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

[Chirag_Gandhi07]

@Claje Thank you!!