Adding comments in formulas with operators +,-,*,/ and with concatenated formulas like “…”&IF(aaa,bbb,ccc) is easy and works well. Turned out to be my favorite undocumented feature of Airtable :winking_face:
More tricky seems are formulas that have many AND and OR arguments that I need to comment. Example:
IF(OR(AND(a=0,b=0,c=0,d=0),OR(e=0,f=0),OR(AND(g=0,h=0,j=0))),"east","west")
I need to add a comment after the string … f=0)
This formula checks for valid (true) result. If you say that IF(X,Y) formula results always in TRUE result, if I put that inside my AND/OR formula, the whole formula may provide incorrect result, because the dummy formula result is always True.
I tried to make something like this here but I am not sure if this is correct logic. Shouldn’t this always result in field result: “east” ?
IF(OR(AND(a=0,b=0,c=0,d=0),OR(e=0,f=0),IF("......this is my dummy formula with a comment.....",0),OR(AND(g=0,h=0,j=0))),"east","west")
Since the dummy formula IF("......this is my dummy formula with a comment.....",0) provides always TRUE response I could put it into another formula that would always generate a FALSE response. Something like this:
IF(OR(AND(a=0,b=0,c=0,d=0),OR(e=0,f=0),AND(IF("......this is my dummy formula with a comment.....",""),0=1),OR(AND(g=0,h=0,j=0))),"east","west")
Am I doing this right?
The “east” and “west” options are just examples. In reality my formula has instead of “east” another formula and it has BLANK() instead of “west”.
Much appreciated and thank you.
