Formula checkbox from report filters

Question

Thank you all for considering my post. I am trying to create a checkbox formula that mirrors this set of report filters:

I am having a Dickens of a time to get the same results as the report displays. Create a new report where [Formula Checkbox] = true and delivers the same results as these filters. I need to pass the Formula check box back to other table(s). Many thanks.

MarkShnierYou · Answer

It's lot of typing so i will do this in pseudo code, but I will endeavour to get the ANDs and ORs correct and the parentheses.
and

[Riversmart home]
and
(isnull([adit date]) or [audit date] < [date reaudit requested])
and
not [test account]
and
[site owner public user]
and
(not [rsr auto enroll] or [rsr autoenroll app date ] < [ date reaudit requested])
and
([remove from waitlist]=0 or not isnull([date reaudit requested]))
and
(not [rsh import] or not isnull([date audit requested]))

Please post back with a copy and paste of the code if it does not work and you can't fix it, ad I will help edit it.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community