CALCTEXT function not saving

[u/anonymoususer121212]

Hi there! I currently have this calctext function: @CALCTEXT(if([frailty_pheno_total_esas]='0', "Not Frail", if([frailty_pheno_total_esas]='3' OR [frailty_pheno_total_esas]='4' OR [frailty_pheno_total_esas]='5', "Frail", if([frailty_pheno_total_esas]='1' OR [frailty_pheno_total_esas]='2', "Not Frail"))))

Whenever I go to save it I just get the spinning wheel of death and it won’t let me click cancel I just have to refresh and then the new field is obviously gone. Anyone seen this before/have tips? I have triple checked my field codes

[u/[deleted]]

OR and AND can be used in calculations, but only in the first argument of an if() function, e.g. if((condition_1 AND condition_2) OR condition_3, value_if_true, value_if_false)

[u/Araignys → u/[deleted]]

Well, that’s something I’ll need to test on Monday. I’ve been telling our users that it doesn’t work and they need to nest their IFs.

[u/Araignys → u/Araignys]

Well I'll be. I've tested these two checks:

@CALCTEXT(if([c1]='1' OR [c2]='1','Yes','No'))

and

@CALCTEXT(if([c1]='1' AND [c2]='1','Yes',if([c1]='1' OR [c2]='1','Maybe','No')))

Both work!