Need help with a formatting expression

AppSheet AppSheet Q&A
,
1

In the app I’m working on, if a student’s projected completion date has passed and if the student hasn’t completed, I want to flag the date by making it red and bold. So I have the following as a formatting condition, because I couldn’t figure out how to exclude the DNF status:

And([projected_date]<TODAY(), 
([status]<>"Completed"))

It works–except if a student’s status is “DNF”, and the projected date has passed, that data also turns red and bold. I want neither for the [status]=“DNF” students.

I created another rule to remove the red formatting, but I cannot un-do the bold text.

How do I add an “exclusion condition” to the expression? If that’s not possible, how do I make some text NOT bold?

2

Maybe this

AND([projected_date]<TODAY(),
OR([status]<>“Completed”,[status]<>“DNF”)
)

1 Like
3

It doesn’t quite work. The result I want, in plain language is this:

When [projected_date]<TODAY() and [status]<>“Completed”, make the letters red–EXCEPT when [status]=“DNF” (even if [projected_date]<TODAY())

How do you express the “EXCEPT” idea in AppSheet?

4

This?

AND([projected_date]<TODAY(),
[status]<>“Completed”, [status]<>“DNF”)

2 Likes
5

Ah YES! That works. Thank you!

Side note: So you can put more than one condition in an expression!

6

Yes, an expression in general can have many conditions. Exceptions are there depending on how you build expression.

1 Like