Formula for Countdown

@SPark · 07/18/19

Hi,

I've read through a few threads and I am unable to re-create a simple countdown formula. I keep getting an #INVALID OPERATION error.

Am I missing something? Please help! Thank you!

Andrée Starå · 07/18/19

Hi,

Are both the Target Date and Today formatted as Date column types?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

@SPark · 07/18/19

Yes, both columns are Date types.

Andrée Starå · 07/18/19

That's strange!

It should work.

Try to change the columns to text and back again and also try to edit the formula and then change it back again. Maybe it's a glitch.

Did it work?

@SPark · 07/18/19

Yes!! That fixed it!! I seriously thought I was going crazy!

Thank you so much for your suggestion, I knew it had to be something simple!

Andrée Starå · 07/18/19

Excellent!

Happy to help!

(I starred at it for a long time as well)

Comments