invalid column value error

System

This discussion was created from comments split from: If And Formula , Return a date.

ChristiannaC

Hi @Andrée Starå!

I am trying to use the principals of this formula with different columns, but I tried copying and pasting the exact formula from this thread first and it is not working for me.

If I replace the ([Realized Date]@row+90) with "True", the formula works.

Thank you for your help!

Genevieve P.

Hi @ChristiannaC

Can you double check your column types?

Both "Realized Date" and the Formula column will need to be Date type of columns in order to add 90 days onto the Realized Date.

Let me know if that helped!

Cheers,

Genevieve

ChristiannaC

@Genevieve P.

That worked - thank you!