If condition help

Hello everyone, i want to make a if condition, if it’s true write yes or ask the original values. How can i do it. It must have a simple solution. But i can’t find, how to ask the orginal values in else condition.

0 2 167
2 REPLIES 2

ycr
Explorer

So, you want to show “Yes” based on the value in a column, if the value not meet the if condition, then show the value? Here is an example: show “Yes” if the original value is blank.

Let’s say you have a column called [ Original Value ]
And You can add a virtual column with formula like:

IF(ISNOTBLANK([Original Value]), [Original Value], “Yes”)

I couldn’t understand it. Let me explain, I have simple options,
Separate Hall, Yes or No
Kitchen Inside, Yes or No

If “separate hall” is yes, insert the “kitchen inside” also yes, if “separate hall” is no , ask if “kitchen Inside” is yes or no.

Please tell me how can i achieve this.

Top Labels in this Space