Imported Data not Matching Up to Columns in Smartsheet

Hi. I have created a smartsheet. I have also created a form, that will contain excel based data to be imported into the SS. Here are the steps I've taken:

*from SS, click on File>Import>Import Excel>Select the file>Continue>see a Message Box with Column Headers. I click on the row that contains Column headers>Import>Form opens.

I then look at the SS and the info has not populated. I have triple checked that the column headers in the excel file are identical to the columns in the SS. I also heard that sometimes data doesnt load directly under the last entry, so I scrolled down and it's not being entered (although the 1st time I tried this, data loaded, but the data didn't match up). What am I missing?? Help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!