Forum Discussion

JASONVOSS's avatar
JASONVOSS
Qrew Member
3 years ago

ToText If Statement Error

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
------------------------------

2 Replies

  • try this

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

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • JASONVOSS's avatar
      JASONVOSS
      Qrew Member
      This put me on the correct path with very little additional items, thanks!

      ------------------------------
      JASON VOSS
      ------------------------------