Can someone help me with a formula? - Please

HCL Domino Domino Forum
1

I am trying to do an excel import into a form that has a field with the formula:

CityContact+", “+StateContact+” "+ZipContact

It errors out on this field with a “Incorrect data type for operator or @ function:Text expected”

I changed the formula to this:

@If(@IsError(CityContact+", “+StateContact+” "+ZipContact); “”;

CityContact+", “+StateContact+” "+ZipContact

I don’t get the incorrect data type error; but it doesn’t populate the field with the city, state and zip. It leaves it blank.

Can someone help me with this?

Thank you in advance.

Helen

2

Subject: Can someone help me with a formula? - Please

Sounds like it should be:

CityContact+", “+StateContact+” "+@Text(ZipContact)

3

Subject: Can someone help me with a formula? - Please

ZipContact is probably being interpreted as a number – use @Text(ZipContact).

4

Subject: RE: Can someone help me with a formula? - Please

Stan,Thank you! thank you! thank you!

You have just made my day.

Helen