Conditional Formatting report

AppSheet AppSheet Q&A
,
1

Hello All..

I have a question regarding “Conditional Formatting” of reports - I have a feeling that this is not possible but doesn’t hurt to ask..

I have a simple report which is working as expected (I have it emailing when needed). First screen shot. What I would like to do is to format the entire row in RED IF the “Urgency Level” is above a certain number (7 or 8). The 2nd screen shot is how I would like it. The 3rd screen shot is the Email template document that I am using.. Very simple.

So I am wondering if this is possible?

Thanks,

RoryF

RoryF_0-1647550928794.png
RoryF_0-1647550928794.png1354×595 12.1 KB

RoryF_1-1647550987391.png
RoryF_1-1647550987391.png1319×588 12.1 KB

RoryF_2-1647551043458.png
RoryF_2-1647551043458.png1682×494 13.6 KB

2

You can’t do it using that template but try this workaround:

Add two [ShortDate], [Name]. [Is…] and [What..] (Also try to change those column names, for long messages use the Display Name field under the editor)

One of them would be this way:

<<If:([What is the urgency level? 1-10]>6)>><<[Name]>><>
<<If:([What is the urgency level? 1-10]<7)>><<[Name]>><>

3

That sound very creative - I like it.. I’ll give it a shot..

Thanks..

4

That works.. thanks. The problem is it leaves a lot of white space between rows but that is down to the long column names - I will work on that..

Regards,

RoryF