Forum Discussion

KellyLyons1's avatar
KellyLyons1
Qrew Trainee
3 years ago

Report formula - multi-select text field

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
------------------------------

3 Replies

  • 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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      If you are still having issues just connect with me by regular email in my signature line and I will sort you out on a quick zoom call. I think you are just way overthinking this.

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
  • BlancaAnderson's avatar
    BlancaAnderson
    Qrew Assistant Captain
    I believe you can achieve that through report filters



    ------------------------------
    Blanca Anderson
    ------------------------------