Invalid column value
Hello, I am trying to reuse a formula I have used in the past and i keep getting the error "INVALID COLUMN VALUE".
The formula is: =[DR Plan Start Date - WKSTRM POPULATES]@row + INT(INT([Duration (DO NOT UPDATE)]@row) / 24)
I confirmed the cells is reading from are date cells and a text number cell. What other reasons could be causing this?
Best Answer
-
It looks like you're looking to add numbers onto a date, to create a new date. Is that correct?
If so, this formula will need to be pasted into a Date Column (not just referencing a date column). Can you confirm that's the type of column that you're using?
Otherwise, to return text in a Text Column, you could add a +"" at the end:
=[DR Plan Start Date - WKSTRM POPULATES]@row + INT(INT([Duration (DO NOT UPDATE)]@row) / 24) + ""
Let me know if this works for you!
Cheers,
Genevieve
Answers
-
It looks like you're looking to add numbers onto a date, to create a new date. Is that correct?
If so, this formula will need to be pasted into a Date Column (not just referencing a date column). Can you confirm that's the type of column that you're using?
Otherwise, to return text in a Text Column, you could add a +"" at the end:
=[DR Plan Start Date - WKSTRM POPULATES]@row + INT(INT([Duration (DO NOT UPDATE)]@row) / 24) + ""
Let me know if this works for you!
Cheers,
Genevieve
-
Thank you! This resolved the issue perfectly!
Help Article Resources
Categories
Check out the Formula Handbook template!