Format Query

Timbo
Participant II

Hi
I have built a app to track my shared tools across the business. I have used a reference sheet and it is going well.

I am just now trying to build a format action to change the colour of some text based on two fields being completed.
I can get it working using “Isnotblank” for one of the fields but cannot work out the expression to get isnotblank for two fields?

Solved Solved
0 2 104
1 ACCEPTED SOLUTION

You may wish to try

AND ( ISNOTBLANK([Field1]) , ISNOTBLANK([Field2]) )

View solution in original post

2 REPLIES 2

You may wish to try

AND ( ISNOTBLANK([Field1]) , ISNOTBLANK([Field2]) )

Steve
Participant V

For reference:

Top Labels in this Space