I have a table of tasks & added a "Sprint" column of type "Number".
I have entered the number 1 into this column for some rows (others remain empty)
If I attempt to filter the table using "Sprint", "=" & "1" (without parentheses), the table is displayed as empty
If I attempt to filter the table using "Sprint", ">=" & "1" (without parentheses), the table shows the rows I want correctly. However, this is obviously a temporary workaround as I would like to filter on exact matches only.
I have tried adding quotation marks to the query but this doesn't make a difference.
I have a table of tasks & added a "Sprint" column of type "Number". I have entered the number 1 into this column for some rows (others remain empty) If I attempt to filter the table using "Sprint", "=" & "1" (without parentheses), the table is displayed as empty If I attempt to filter the table using "Sprint", ">=" & "1" (without parentheses), the table shows the rows I want correctly. However, this is obviously a temporary workaround as I would like to filter on exact matches only. I have tried adding quotation marks to the query but this doesn't make a difference.