This may seem really basic but I'm struggling to get my head around it. I have 2 boolean columns (Checked by TL and Checked by CSS), I need a calculated column to give me one of three results;
1: Checked by Both - this is where both of the columns are True
2: Checked by CSS - this is where the Checked by CSS column is True and the Checked by TL column is False
3: Checked by TL - this is where the Checked by TL column is True and the Checked by CSS column is False
I may have used the right formula in my testing but kept getting a syntax error which I couldn't fix by bracket counting so I'd appreciate any help with this one
Solved;
=IF(AND([Checked by CSS]=TRUE,[Checked by TL]=TRUE),"Checked by Both",IF(AND([Checked by CSS]=FALSE,[Checked by TL]=TRUE),"Checked by TL",IF(AND([Checked by CSS]=FALSE,[Checked by TL]=FALSE),"Unchecked",IF(AND([Checked by CSS]=TRUE,[Checked by TL]=FALSE),"Checked by CSS"))))