I was looking for this option but cannot find any suitable function for this operation. Is the operation supported in the current implementation?
Equivalent in Excel: if function
Equivalent in Sql: case when statement
Yes a similar function is on the roadmap.
In the meantime, some functions can be used to deal with conditions such as compare or match. They will generate a decision i.e true/false, you can then filter on true and apply a function on this subset.