I am using a SWITCH function to say if Status equals A or B then “Good”, if Status equals C or D then “Maybe” and so on. My question is there a way to not use text in quotes for outputs but reference a table that has the options Maybe and Good listed. I may change the names later so I want them connected but I can get the formula to pull the table chips properly. I am not sure if there is a special way to do this. If I just do one of the .Status= ?? then the chips show up but not when I put them in a more complicated formula.
My question is there a way to not use text in quotes for outputs but reference a table that has the options Maybe and Good listed.
Yes, if you want to make it “dynamic”, change them to “table chips” as you’ve put it.
then your best friends in these scenarios would be .Contains() , In()
. I am not sure if there is a special way to do this.
Change your column to a relation or select column.
If I just do one of the .Status= ?? then the chips show up but not when I put them in a more complicated formula.
this one is a bit of a quirk and how i tackle this is, i would put in formula editor Switch(Status =, then start with first option you need and then cut and paste it for use to the rest of your formula. Then do next option. Basically i cycle through each and every option i need, then delete the = after Status to finalize the formula. Its easier to find all your options/chips this way.
Hope this makes sense and helps!
Figured it out. I didn’t quite realize since I was referencing another table I had to use filter. I was just trying to get the column to equal the value in the select table which didn’t work. Thank you again
awesome to see you got it working @Chris_DeAngelis !
just note, doing it this way doesnt make it dynamic and defeats your original intention. It will break when you change the live status text e.g. In progress to Progressing.
dynamic - “chip” by way of current value OR you can just type “@In Progess” in formula bar and there will be an option to select (make sure its from Live Status table and not another table if you have others)
That is really interesting. When I created the formula it was a chip. But then the system converted it to quotes. But when I selected it using @ it stayed as a chip. I noticed this a couple times yesterday. I didn’t realize the one I copy/pasted had converted to text.
Got it. Thanks so much. I have been looking for CurrentValue type solution and couldn’t find it (it is not on the formula page).
