I am trying to get an up arrow in a simple weight tracker if weight is higher than before, as in, value in cell below in higher than value in cell above.
I am using format rules, I understand how to set the icon. I havenโt been able to get the formula right. Would really appreciate some help with this!
Solved! Go to Solution.
Try:
ISNOTBLANK(
FILTER(
"table",
AND(
(
[_ROWNUMBER]
= MAX(
SELECT(
table[_ROWNUMBER],
([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
)
)
),
([weight] < [_THISROW].[weight])
)
)
)
Replace table
with the name of the table and weight
with the name of the column you want to compare.
Try:
ISNOTBLANK(
FILTER(
"table",
AND(
(
[_ROWNUMBER]
= MAX(
SELECT(
table[_ROWNUMBER],
([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
)
)
),
([weight] < [_THISROW].[weight])
)
)
)
Replace table
with the name of the table and weight
with the name of the column you want to compare.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |