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 (
) 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
