Unparsable IF( & Gantt

TBurnett

I'm trying to make my Gantt display carry my current projects out with a hidden "completion date" row and IF= code, but it won't work. If my unhidden completion date cell is blank, I want it to autofill todays date so my gantt will show current projects, but if my viewable completion cell has a date in it, I want it to copy that data into the "hidden gantt metric" cell. Here's what I'm trying to make work:

=IF([Completion Date]@row="", =TODAY(0), [Completion Date]@row])

All columnns are set to Date.

Nic Larsen

Try: =IF(ISBLANK([Completion Date]@row), TODAY(), [Completion Date]@row])

dojones

Try this: =IF(ISDATE([Completion Date]@row), [Completion Date]@row, TODAY())