Skip to main content
Question

Problems with if statement in User Formula field

  • January 5, 2021
  • 0 replies
  • 109 views

MattMakris
Forum|alt.badge.img+7
I am trying to use an if statement in a user formula field and it doesn't seem to be working. It is designed to determine whether a checkbox is checked, then outputs a user field value based on the condition.

If ([my checkbox]=true,
  [user field A],
  [user field B (via relationship)]
)


I am getting the following error with the field in the else output highlighted:
"expecting text but found user"

Any ideas?


------------------------------
Matt Makris
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Change the field type to formula user and it now seems to be a formula text field type.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------