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

Kayleigh Colon

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!

Kayleigh Colon

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!!

Jeremy_D

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

Jeremy_D

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

RDRGSJ00

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

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.

Kayleigh Colon

https://community.smartsheet.com/discussion/comment/448723#Comment_448723

Thank you for your help!

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

Kayleigh Colon

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!!

Jeremy_D

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