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/Con...
Forum Discussion
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
------------------------------
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
------------------------------
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
------------------------------
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
------------------------------
- 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
------------------------------- Can you describe your relevant tables in their relationships?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- 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
------------------------------
