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
MarkShnier__You
Qrew Legend
Qrew Legend//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
------------------------------
Split([my semi delimited text field])
That will allow dynamic filters for each unique choice
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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
------------------------------
- MarkShnier__Yousorry 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
------------------------------- 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
------------------------------- MarkShnier__YouCan you describe your relevant tables in their relationships?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------