Filter by Formula Column number

I’m attempting to make a dashboard that shows all items with a margin under 5%. We use a formula column to calculate margin, and I’m unable to filter based on this.

I want to filter it like:
“Where [Margin] [is equal to or less than] [5]”
and Margin is a Function column

Is this possible? Or will I just have to copy the result of the formula and put it in a numbers column?

Hello @klewis - yes, this is possible in a dashboard to use common numerical operators:

Please note, monday is rolling out an “All Boards” filter for dashboards (:partying_face::partying_face::partying_face:) and we have noted that when the “All Boards” option is selected, the formula column is then treated like a text column. See the comparison below:

Single Board Selected:

All Boards Selected:

I would double check this first.

Hope this helps!
Mark

1 Like