Skip to main content
Question

ToText If Statement Error

  • April 25, 2022
  • 0 replies
  • 91 views

I am working on creating a Summary Field from Formula - Rich Text and keep getting the error "The operator "<>" can't be applied on types textlist, text".

Formula = List("\n", If([Field 1]<>"", "Summary Text 1:" & [Field 1])

The below formula is nearly what I want, but I don't want to summarize the field if the field is blank and the below formula still adds the "Summary Text 1:" if the field is blank.

Formula = ToText("Summary Text 1:" & [Field 1])


Thanks!

------------------------------
JASON VOSS
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • April 25, 2022
try this

List("\n", If(ToText([Field 1])<>"", "Summary Text 1:" & [Field 1])

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------