Logging an Action

[Qiro]

I'm very new to Appsheet and I'm not sure how to ask for what I need!

I have a sheet (Log) that records if someone is allocated an asset from another sheet (Devices). The problem is the bot I created doesn't know whether the asset is being signed in or out.

To fix this issue, I created a manual button to return all assets to inventory, but here's where I'm stuck.

I'm looking for an expression that will check to see if (Log) cells A2, B2, and C2 are empty. If they are, that means they have nothing assigned to them anymore and so it should output "Signed In" to D2.

Sounds pretty simple and I can do it in Google Sheets with something like this:

=IF((SUMPRODUCT(--(A2:C2<>""))=0),"Signed In","")

but that doesn't work within the app.

Any help would be gratefully received!

[Lynn · Accepted solution]

Hi @Qiro 

Have you had alook at ISBLANK?

https://help.appsheet.com/en/?q=ISBLANK

[Qiro]

Hi Lynn,

IF(AND(ISBLANK([A]), ([B]=""), ([C])=""), "Signed In", "Signed Out")

This was my solution, thanks.