Of course!
This is all pulling in from a connected table, so no table-to-table relationships. The summary report is summarizing Facility Name, grouping rows by Initiative Type and then grouping columns by Entitlement Type which is the multi-select field.
The entitlement type field can have any of the following selected:
None (ministerial approvals only)
Site Plan Approval
Special/Cond. Use Permit
Rezone
Variance
PUD
SEQUA
Text Amendment
SEQUA Negative Declaration
SEQUA Environmental Impact Report
We would want each column broken out to be one of the options above and then show the total count, unlike how it is currently breaking them out to show all the possible combinations. I was thinking this could be done with multiple formula fields, but was wondering if I could write one formula that would achieve the same look.
------------------------------
Sarah Driscoll
------------------------------
Original Message:
Sent: 11-15-2022 15:25
From: Mark Shnier (Your Quickbase Coach)
Subject: Segregating Info in Text Field Formula
Can you describe your relevant tables in their relationships?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 11-15-2022 15:24
From: Sarah Driscoll
Subject: Segregating Info in Text Field Formula
So sorry, I meant column.
So column 1 would have all the Initiatives
Column 2 would be how many have Site Plan Approval selected
Column 3 would be how many have Rezone selected, etc.
------------------------------
Sarah Driscoll
Original Message:
Sent: 11-15-2022 15:17
From: Mark Shnier (Your Quickbase Coach)
Subject: Segregating Info in Text Field Formula
sorry I'm not understanding this
and then have another row show many might have Rezone selected.
Did you mean another column?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 11-15-2022 15:03
From: Sarah Driscoll
Subject: Segregating Info in Text Field Formula
That worked perfectly!
Another question. We would want to see how many sites might have Site Plan Approved as an option and then have another row show many might have Rezone selected. Is there a way to do this with one formula instead of multiple? Would it be a report formula?
------------------------------
Sarah Driscoll
Original Message:
Sent: 11-15-2022 13:08
From: Mark Shnier (Your Quickbase Coach)
Subject: Segregating Info in Text Field Formula
//Field type Formula Multi Select Text
Split([my semi delimited text field])
That will allow dynamic filters for each unique choice
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 11-15-2022 11:40
From: Sarah Driscoll
Subject: Segregating Info in Text Field Formula
I currently have data pulling in from another source via a pipeline. In the original source, the field is a multi-select but when pulling in they are separated by a semicolon (ex: Variance;Special/Cond. Use Permit)
I am trying to figure out how to write a formula to convert this info from the text field into a multi select, allowing for teams to easily see all the different options selected.
------------------------------
Sarah Driscoll
------------------------------