+1 for phone numbers formula problems


I have a column for phone numbers that come in from the form and they come in with the +1 format. in the column right next to it I'm trying to write a formula so that if the phone is blank it gives N/A.

=IF([Mobile Phone]@row > 0, "[Mobile Phone]@row", "N/A")

I know my problem is the + sign because if I remove it the formula works fine however I need to process to be automated and I don't want to have to come in and remove every single + sign when the form automatically puts it there. Any help? Thanks

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!