Format Query

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?

You may wish to try

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

2 Likes

For reference:

1 Like