I need some guidance on creation of a calculated field column...
I have two columns that should dictate the value in this calculated field
TCV and F01....
If F01 = No the field is blank
If F01 = Yes and TCV GT or = 25000000 the field = CEO/COO
If F01 = Yes and TCV < 25000000 the field = BG Group