My formula results in "NaN". What does that mean?

B

B S

I am working on form that will be emailed once completed. The user will
click on a button that will email it to a specific account. I want the
formula to automatically pull two fields and place them in the subject line
of the email along with a short text. I type in the formula and verify it
and no errors come back but, when I send it the subject line comes out with
"NaN". How can I fix this? Here is the formula I am trying to use:
string("TEC Request for - ") + string(AreaRegionCOSA + ProjectActivity)
 
F

frebou

NaN = Not a number.

He is probably trying to "sum up" the string with the number. Ensure your
using right concatenation method and that everything that you "+" are
number...
 
A

Art

I always use

concat("TEC Request for - ", AreaRegionCOSA, " ", ProjectActivity) and it
always work fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top