I’m having a difficult time with a Select List column.
No I can’t share the document so please don’t ask.
If I use this formula:
In a SELECT column then the field shows up properly and allows me to CHOOSE an item from the list.
MonthlyHabits is a related field from the Monthly Plan table.
This allows me to choose only ONE item.
If I change nothing but change MULTIPLE SELECT to on then it messes up the items and just shows me a “list” with it looking like [habit one, habit two, habit three, etc.]
WHY? This is not right. If my select list is written properly then I should be able to choose multiple items or not choose multiple items.
Basically I have:
Habit – select list from Habits table
Objective – choose the ones to work for this month
Habits – pulls habits associated with these objectives
Month – link to Monthly Plans
Weekly Habits – I want this to be a SELECT field that populates from the Monthly Plans Habits.
As I stated it works properly if I do not allow MULTI SELECT but that’s useless as I want to select as many as I want.
I’ve tried at least a dozen ways to do this with just selecting directly from HABITS and then trying to FILTER that select and it just gives me crap every time. This is a very simple thing yet I’ve spent two days trying to make it work. It shouldn’t be this difficult and I’ve scoured the Community posts and find bits and pieces of useful information to try but I’ve found nothing to fix this. Every version of FILTER I’ve tried on the Habits table just results in junk or an error. I’ve written hundreds of filters but FILTER inside a SELECT isn’t working as it should. What am I missing?