Hi you all! I had another question. I want t...

(Aparicio Piñeyrúa) #1

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?

(Praveen Seshadri (AppSheet)) #2

Try the condition [Changetimestamp] > TODAY()

#3

Or possibly >TODAY()-1

may work?

(Praveen Seshadri (AppSheet)) #4

TODAY() - 1 should show everything yesterday and today

(Aparicio Piñeyrúa) #5

@praveen

Thanks!

I will try that!