How do I use the import function to delete specific address field data?
Sorry if this has been posted already but I'm not finding the guidance I need.
I'm trying to update records that have data in the wrong fields. For example, I have Record 1 that has no data in the "State (Mail)" field but does have data in the "State (Other)" field. I need the "State (Mail)" field to be populated with new data and the "State (Other)" field to be changed to blank.
I downloaded all my contacts, including the Record ID, and updated the CSV file as needed. In my test upload, though, the fields that are now blank in my spreadsheet didn't get removed in Insightly.
How do I format the spreadsheet to indicate that any blank field in the spreadsheet should be blank in Insightly?