Format Query

[Timbo]

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?

[Suvrutt_Gurjar · Accepted solution]

You may wish to try

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

[Steve]

For reference:

help.appsheet.com

AND()

Are all true?