Format rules Multiple conditions

AppSheet AppSheet Q&A
1

I am trying to write a formula for a format rule that looks at two things. Whether the equipment is active and running and who created it. I have a user column. But I have multiple users. I want different colored dots next to the equipment name of who started it.

This is my formula now.

myra_o_0-1691953781056.png

It shows all the equipment with a green dot next to all the equipment that is active not just the ones created by the current user. Any ideas? Thanks in advance.

2

Without knowing your table/column structure, probably something like..
AND(
IN([Equipment name],Active1[Equipment]),
LOOKUP([_THISROW].[Equipment name],Active1,Equipment,User)=USEREMAIL()
)

1 Like