Invalid column value

Brenna Saunders

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?

Genevieve P.

Hi @Brenna Saunders

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

Genevieve P.

Hi @Brenna Saunders

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

Brenna Saunders

Thank you! This resolved the issue perfectly!