Any suggestions on a formula to test for a null userlist field?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
We want to test which of two listuser fields is not blank and then report that value (the property manager can come from either the 'Property Manager' or 'Project - Property Manager' field.  The purpose of the field is to have a single column for property manager on the report.

The following formula works for a similar text multi-line field, but not for a listuser field.

If([Unit - Tenant Name] <> "", [Unit - Tenant Name], 

If([Project - Unit - Tenant Name] <> "", [Project - Unit - Tenant Name], [Unit - Tenant Name]))


Any help is appreciated.


Ron
Photo of Ron

Ron

  • 50 Points

Posted 2 years ago

  • 0
  • 1
Try this

If(

not Isnull([Unit - Tenant Name]), [Unit - Tenant Name], 

not Isnull(Project - Unit - Tenant Name]), [Project - Unit - Tenant Name], [Unit - Tenant Name])
Photo of Ron

Ron

  • 50 Points
Worked great, thanks!
Glad its working.