@RandyHayes
Hello,
I have a gallery with a Mechanical Engineer column which is a person field. If an ME hasn't been assigned yet, the column is set to Pending as per this Text formula:
With({dn:Match(ThisItem.'ME Assigned'.DisplayName, "^.*\s.").FullMatch},
If(IsBlank(dn), "pending", dn & "."))
I would like to set any Pending items to Red so they stand out more as an item that needs to be addressed. Can someone help me figure out how to set the Color property to achieve this? Thank you, Teresa
