Formula to show Yes or No based on three fields

[paul123]

I would like to use a formula to create a fourth column for the table below.  The column should reurn a yes if both the Maths SS and Reading SS are above 95 and the WR On Track is a yes.

Would really appreciate some help

[Primrose]

Hi @paul123 

You may use If() & AND(). Something like If([Maths SS]>95 AND [Reading SS]>95 AND [WR On Track]='Y', 'Yes', 'No').

If you have access to the load script, I would recommend you to move that to the script. When you use If() on the front-end, this results in a prolonged time for estimation and therefore loading the chart. By adding this to the script, you can optimize this. 

You may check other discussions about IF(). They'll help you understand better how this works in QS.

[paul123 · Accepted solution]

Great - huge thanks.  All sorted.