You need to sign in to do that
Don't have an account?
Andrew Lees
checkbox fields in formula
I have two checkbox fields basically "#OPEN" and "#CLOSED". Bad design, I know, but not my doing! Anyway, I want to combine them into a single field with an IF statement.
Essentially, something like IF(#OPEN=TRUE, "Open", "Closed")
But I don't know how to treat the check in a checkbox. Is it "TRUE"? I keep getting a syntax error.
Hope that's not confusing. This should be easy...
Essentially, something like IF(#OPEN=TRUE, "Open", "Closed")
But I don't know how to treat the check in a checkbox. Is it "TRUE"? I keep getting a syntax error.
Hope that's not confusing. This should be easy...
The return type of formula will be text