Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy
I finally figured out a formula i have been working on for few days ...
strangest thing it seems to have been the quotes that i was using ??....
I used the quotes (directly to the left of the enter key with shift ) as a blank and i would get an unparseable error .... i then copied the quotes from the smartsheet community example and walla - they work ...
as i was testing - see underlined below .... the first set of quotes - copied from smartsheet ; then using various quotes on my keyboard.. and a fyi all the font is arial and the size is 12 ..
when you zoom in you can see they are indeed different .. but that leaves me with .. what quotes do i use ? i can't always copy smartsheets community pages ha
example: [IP Assigned (if needed)]42 = "", “”, ‘’’’, “”, ````
Help Article Resources
Check out the Formula Handbook template!