Skip to main content
Question

If Statements with inches

  • July 18, 2022
  • 0 replies
  • 26 views

Forum|alt.badge.img+3
So I may have caused myself issues with my setup.  But my problem is doing If statements with conditions which have an Inch (") in the name.

Ceil(If(="Per Piece",

IF ([Material Description]="WEEP AID",[Plan/Trade Product Line - Plan - Bid Set Weep Aid]/,[Material description]="4" DIAMOND LATH STRIPS",0),0)
)

I stopped because I have numerous Material Descriptions which include (") identifier in the name such as the Diamond Lath Strips. I guess I could go through and change all the names to read inch but there's a lot of them.  Is there a ' function which allows me to bypass the problem?

------------------------------
Paul Elliott
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+6
Haven't tried it, but generally you have to escape the restricted characters:

"This is the  \"Younameit\" Product" 

------------------------------
Malcolm McDonald
------------------------------