Formulating

[Sunilmnv]

Hello there, team.
I need your help in formulating.

I've got two columns, a and b. If a=fail, then the b column should not be empty.

[DataNath]

@Sunilmnv this is a little vague. Are you saying where [a] = fail and [b] is empty, you want to filter those out? Or you want to populate [b] with a certain value? What does your input look like and what do you want the outcome to be? Would be great if you could provide an example.

[IraWatt]

Hey @Sunilmnv,

Does this give the logic your looking for?

The formula passes the value for B if A = "fail".

Any questions or issues please ask :)
HTH!
Ira

[Emeritus001]

Hi @Sunilmnv, may I ask for further details on the condition like what could be other text in the column A aside from 'fail' and if column B should not be empty, what data should be written in there.
Anyhow, I wrote a simple workflow that satisfy basic condition. You may change the formula as you desire.

[Sunilmnv]

It’s a free text any thing can be written but should not be blank