Smartsheet to Excel via Power Query

Joshua Conde

Hello,

I have ran into an issue where parts numbers get recognized as null by Power Query if the column type is text. When exporting the Smartsheet there are no issues what so ever but depending on the length and contents of the part number it will get dropped. Please refer to the below image.

Pauline J

Hi @Joshua Conde

If I understand your situation correctly, it sounds like your numbers in Smartsheet may not all be "numbers" — some may be formatted as text. I would suggest selecting each column of numbers and formatting them as numbers (see below.)