Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    I am trying to Set up a 'Turn Around Time', but I am getting '#InvalidColumnValue' or 'Unparseable'

    ✭
    in Formulas and Functions

    I have a basic sheet that I am going to import an excel sheet into every morning. It is for sample release testing. I have a column for the date that the sample was logged in, and one for when the sample was approved for release.

    I want to calculate the days it took from log in to approved. I have tried a few formulae that I found here, but I can't seem to get it to work. Here is what I have tried:

    =([SLIM Approved]@row - PARENT([Log In Date]@row) ERROR: #INVALID COLUMN VALUE

    =[SLIM Approved]@row - [Log In Date]@row) ERROR: #UNPARSEABLE

    Here is a screenshot, sorry for the scribbles!

    image.png
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answers

    Answers

    • ✭✭✭✭

      Hi Kayleigh, the second simple formula should work, I think you just need to remove the last outer bracket if you included that so the formula would just be:

      =[SLIM Approved]@row - [Log In Date]@row

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      Hello Kayleigh,
      Could you provide more context? I setup a similar sheet:

      image.png

      Column Breakdown:
      [Log In Date] column is of type Date

      [SLIM Approved] column is of type Date

      [Days Took] column is of type Text/Number

      In [Days Took] I have:

      =[SLIM Approved]@row - [Log In Date]@row

      and it works fine.

      · Share on FacebookShare on Twitter
    • ✭
      Jeremy_D

      Thank you for your help!

      I took out the extra bracket, and now I am getting #INVALID OPERATION

      · Share on FacebookShare on Twitter
    • ✭
      Answer ✓

      I figured it out, it was such a silly mistake on my part!

      I had the Log In Date put in the Primary Column! So, all I did was create a new column as my log-in date and left the primary empty. Now it works :)

      Thank you both so much for your help!!

      · Share on FacebookShare on Twitter
    • ✭✭✭✭
      Answer ✓

      We've all been there! Glad you worked it out :)

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions