Text columns formatted from Excel Import

Options

Hey there!

Has anyone experienced a text/number column containing an apostrophe before the value upon the Excel import? And if yes, how do you correct this?

Answers

  • Samuel Hollis
    Options

    Hi, I know that in excel you put an apostrophe in front of something you want excel to read as text. For example, if you want a cell to show the formula its using, you can put an apostrophe in front.


    So I'm thinking it might be a data type problem and smartsheets thinks your importing strings(text)?

    What do your cells look like in Excel? Do they have formulas or values or both?

  • Cinda.q
    Cinda.q ✭✭✭✭
    Options

    I will check will the person that imported the data, but in the meantime do you know if or why this would impact the filter results?

    Using the 'Contains' filter the results only populate with the data that contains the apostrophe

    Using the 'Is one of' filter the results populate with all outcomes (apostrophe or not)

  • Samuel Hollis
    Options

    I would have to do a little experimenting to answer your question because I don't really know. I do know know that the "contains" filter is text filter only in excel. That could be a thing. Let me see if I can replicate the problem and get to the bottom of it.

  • Cinda.q
    Cinda.q ✭✭✭✭
    Options

    This is my assumption based on the outputs: I think what the "contains" filter is doing is looking for the desired info within a string of data and if the output is not in conjunction with other values it won't populate as a result

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!