I am trying to get the format text based on the value of the scanned column. I just want the text to change color is the value is larger than 1. I can’t seam to get it to work because of the " ( ) " brackets. It is a virtual column if that makes any difference.
“Scans” seems to be a List column, which is created by the system and it’s named [Related something] by default.
This “NameOfColumn (items)” is the way is shown on some list views, but you need to count the number of items by yourself.
This is done this way:
COUNT(
[YourColumn]
)
Then you can just compare the result with any other value you need, like this way:
COUNT(
[YourColumn]
)>1
1 Like
You can also try “Extractnumber[Scans]>1”
1 Like
How?
It will remove every letter, space and anything else that isn’t a number and then you can apply this logic.
1 Like