Formula for Days to Complete coming up #UNPARSEABLE

Sam Clapp

Screenshot 2022-11-01 084509.png

I'm trying to calculate Days to Complete with the attached columns, but it keeps coming up #UNPARSEABLE. Any idea why? Am I missing something?

Paul Newcome

You need some kind of row reference.

=[Due Date]@row - [Date Completed]@row

Paul Newcome

You need some kind of row reference.

=[Due Date]@row - [Date Completed]@row

Ray Lindstrom

Hi @Sam Clapp,

In your screenshot, the only thing you're missing is the @row for your column reference.

=[Due Date]@row - [Date Completed]@row

You can also try this as typically 1 day is returned as .375.

=ROUNDUP(([Due Date]@row - [Date Completed]@row), 0)

Hope this helps!

All the best,

-Ray