Reference one cell value being less than another

Hi All!

Just a quick one, have a column labelled ‘Restock Level’ which each cell contains a numerical number. I want to create a rule like this [Current Stock] < [Restock Level] to say that that item will be shown when the ‘Current Stock’ level is less than the ‘Restock Level’ but when I enter it as an expression I get the error Arithmetic expression ‘([Current Stock] < [Restock Level])’ does not have valid input types. It works if I replace ‘Restock Level’ with a number in the formula but I want it to reference the number entered in the cell. Any ideas?

Many Thanks,
Darren

Hi @Carbretta
What is your expression and where are you putting it?

1 Like