I don’t see why this doesn’t work. Formula Workshop says an operand is where an operator should be. But I don’t see where an operand would fit in place of an operator. I’ve looked around for comparable examples that work, and I’m still stumped. Note: the bracketed text is a placeholder.
?(SENDER PROFILE URL = “[the url]”, RECIPIENT PROFILE URL, SENDER PROFILE URL)
To Panorama, SENDER looks like an operand. It expects that to be followed by an operator, but it is followed by PROFILE, which looks like another operand.
What are SENDER PROFILE URL and RECIPIENT PROFILE URL?
If those are actual field names, then it doesn’t work because of the spaces. The reason for the specific error message you see is because Panorama thinks SENDER is an operand, and PROFILE is another operand. You can’t have two operands in a row, there has to be an operator in between.
If a field or variable contains spaces or other punctuation, it has to be surrounded by chevrons when used in a formula. So your formula would have to be:
?(«SENDER PROFILE URL» = “[the url]”, «RECIPIENT PROFILE URL», «SENDER PROFILE URL»)
Thank you, Dave and Jim. The formula works now.