Hi you all! I had another question.
I want to change the color of an entire Row based on a Changetimestamp. How can I create a format, that only change the color of that entire Row if the Changetimestamp is “=” TODAY?
My Changetimestamp column is looking for all the columns of the table, soo if any changes happen it trigers the action of Changetimestamp.
Then I create virtual columns that Fetch Year/Month and Day of the
Changetimestamp column.
I made a format rule: AND(([Changetimestamp]=[Year Changetimestamp]),([Changetimestamp]=[Month Changetimestamp]),([Changetimestamp]=[Day Changetimestamp]))
The result is that is changing the color of all the data.
How can I only change the colour of the particular Row that has change the Changetimestamp?
Try the condition [Changetimestamp] > TODAY()
Or possibly >TODAY()-1
may work?
TODAY() - 1 should show everything yesterday and today
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |