Help with a status update build off dates.

MilesinAtl

I am working with a smart sheet and want to update the status column with a drop-down value, pulling from the Schedule Delta%, which is fed by the next two columns: the Schedule Delta (working days) and duration columns.

This is the formula on the sheet when I took over a project. I don't know what to do with the #REF. I really appreciate any help you can provide. The cell's value is error #UNPARSEABLE

=IFERROR(IF([End Date]@row = #REF, 0, IF([End Date]@row > #REF, NETWORKDAYS(#REF, [End Date]@row) - 1, IF([End Date]@row < #REF, NETWORKDAYS(#REF, [End Date]@row) + 1, ""))), "")"

Popular Searches

Formulas and Functions

Project Management

Reporting

Paul Newcome

Try replacing each #REF with TODAY() and see fi that gives an output that makes sense.

Paul Newcome

It looks like a column that the formula had been referencing was deleted. What is the expected output?

MilesinAtl

The project status is updated in the summary sheet based on the outcome. Do you have any idea what I could have been referencing, or how you would have written it?

Paul Newcome

Try replacing each #REF with TODAY() and see fi that gives an output that makes sense.