How to do conditional formatting in Report? ...

(John Henry Joseph) #1

How to do conditional formatting in Report?

I have a field called “Status” and possible values are “DONE” and “NOT DONE”. I have done format rules in such a way that “DONE” will be green and “NOT DONE” will be red.

When i have them on a report, it prints in black color.

How do i achieve this?


1 Like
(Reza Raoofi) #2

I think in reports formatting is controlled by the template (i.e. Google Doc), therefore you cannot dynamically change formats based on the column’s value from AppSheet.

(Aleksi Alkio) #3

Actually… you can:D

(John Henry Joseph) #4

@Aleksi_Alkio How? Please

(Aleksi Alkio) #5

<<IFS([STATUS]=“DONE”,[STATUS])>><<IFS([STATUS]=“NOT DONE”,[STATUS])>> Then choose different color for both formulas. When the other one is blank, you just don’t see it :slight_smile:

1 Like
(John Henry Joseph) #6

@Aleksi_Alkio Great…Short and Simple Logic… Thanks lot

(Aleksi Alkio) #7

You’re welcome