I am using Google sheets connected to webhooks to post data to my crm. The CRM requires the state field as a number. So Alabama or AL = 1.
Can I use formatter to accomplish this? I need it for 15 plus states. It needs to read the sheet and if it sees the state name or abbreviation in the state field it will post the the proper numeric number to the CRM