Hello Thomas, Sorry for the delay in getting back to you and this, were in the middle of a project, people on holiday so my time has been used else where, would love a live example if possible when you can.
Thomas_Jaccino:
IF(IF(Category=“Main Stages”, TRUE(),FALSE()),Hours_Done & " - " & Stage,"[Non-Main Stage]")
Thanks for the effort, that line in itself was illuminating, however seems we may have crossed wires.
I was expecting the hour totale...
Hello Thomas, Thanks for the heads up, yes I come to realise that this is not even remotely Excel like.
Pic with Formula below I hope will now make sense in what I am trying to do.
I understand that columns can only have one function.
A IF(Category...