Report formula - multi-select text field

Question

I am trying to add a report formula to get all records based on 2 different fields within the same table. The first field type of a text lookup field, it displays a list of operating facilities. Once I have the correct operating facility, I then want to get a list of records from a multi-select field, both are in the same table.

For example:
Get all records for X operating facility
Then list all records where status =
Secured
Pending
Onboarding
Proceed
Repeat

I have separate reports created for each operating facility, I prefer to have all my records related to each facility listed in separate report......

Any ideas of how to write this out?

------------------------------
Kelly Lyons
------------------------------

MarkShnierYou · Answer

Why don't you just make a table report sorted by Status, and then have a dynamic filter where you can limit the report to which ever operating facility you choose. You would probably also want to have the status be a dynamic filter as well.

If that doesn't solve your problem please explain a little more what the issue is.

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

Sign up

Login to the community