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?
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: