I am trying to Set up a 'Turn Around Time', but I am getting '#InvalidColumnValue' or 'Unparseable'
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!
Best Answers
-
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!!
-
We've all been there! Glad you worked it out :)
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
-
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.
-
Thank you for your help!
I took out the extra bracket, and now I am getting #INVALID OPERATION
-
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!!
-
We've all been there! Glad you worked it out :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!