Conditional formatting does not work properly for file size
I try to implement a color coding for file sizes in the media library with conditional formatting. However, this does not work as expected.
The rule “File size greater than 150” matches the following file sizes:
548 Bytes
2.07 KB
162.55 KB
204.14 KB
76.36 MB
The rule does not match the following file sizes:
1.24 KB
10.04 KB
108.6 KB
146.57 MB
It makes no difference if I set the value to 15, 150, or 15000000 – therefore it is not a problem of the underlying unit (Bytes, KB, MB).
My assumption is that the file size is wrongly treaded as a string instead of a number here.
Thanks for your feedback.
We’ve changed this for the upcoming release.
I will now handle the numbers on the table, but it will not look at the actual suffix (bytes, MB, kb).
If the unit is not evaluated: Do we provide our values as bytes, kilobites or megabytes?
The issue is that Conditional Formatting operators don’t have context for units. For the File Size column, this means that when you use numeric operators such as greater than or between, the unit (KB, MB, etc.) is ignored.
To resolve this, we can standardize all file sizes to a single unit (for example, MB). However, there is currently no way to indicate this in the interface, so users will need to know to enter their values in MB when setting up rules.
We’re inclined to choose MB as the standard unit. Would that approach work for you?
You must be logged in to reply to this topic.