Hi everyone!!!
other problem!!
I’m trying to create a Format Rules.
I have a column called “F” type duration which makes me the difference between two time columns, and a column called “Target F” with type Time.
Column “Target F” always has a fixed value for example 00:23:00, while column “F” can vary.
I entered this formula that colors a data red but it doesn’t work, it colors all the data red.
[F]> [Target F]
Example if “F” is greater than 00:23:00
Please try making [Target F] 's fixed value as “000:23:00” instead of “00:23:00”. If you are having this fixed value in the column’s settings and not reading from spreadsheet, please ensure to include it in double quotes.
Edit: “000:23:00” converts the value to a duration. “00:23:00” denotes a time value. One reason of your current comparison failing is because a duration value [F] is being compared with time (“00:23:00”)
THANKS A LOT!!!
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |