are you using the double quotes around Approve in ...
# general
g
are you using the double quotes around Approve in your formula? If so, you'd need to use single quotes.
d
Thank you it works! by any chance, do you how to make the approved checkbox appear in the saved search? I cant seem to find the field. I
g
I'm not sure - it might not be available as a results column if you can't find it in your search. Maybe it's possibile to put the field id in a formula (text) to display the value?
d
I'd like to put in the result tab a formula when approved is checked, the field is "approved" if not checked then empty. can that be done?
g
case when {approved} = 'T' THEN 'Approved' ELSE NULL END
maybe that will work as a formula (text) field.
d
tried this already but it results to "error: field not found", thank you tho. appreciated :)