JASONVOSS
4 years agoQrew Member
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
------------------------------
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
------------------------------