Skip to main content

Hello, I have built an interface on top of a table. Within this table I have dates and I have put a column formula to get the week number. I've created a chart in the interface and I'd like a drop-down that filters by the week number but currently only allows me to filter by the date. Please help.

Hey ​@kingbee_c.c.s,

This is a fun workaround that you’ll need to build for dropdown filters on interfaces:
1. Go to your “Week” field, and click on “Formtting”
2. Make sure to toggle on the “Output to single select”
3. Type all weeks 1 to 52 (I know, this is a pain)
4. You can now use this field on your interface as a dropdown filter!

 



Mike, Consultant @ Automatic Nation

You’re going to need a single select field to use as a filter for this I’m afraid

I usually output the weeknumber + year to futureproof it and get an automation to paste the value from the formula field into a select field to handle this

Thank ​@Mike_AutomaticN unfortunately the only options I get are Number, Currency, Duration, Percentage. No options to change formula output to single select options.

 

Thank you ​@TheTimeSavingCo I understand this work around and I’ll look into it.

Reply


Terms & Conditions