Formula error

FTesseneer

This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project.

=IF([% Complete]@row = 1, "", NETWORKDAYS([Planned End]@row, TODAY()))

Thanks,

Freda

FTesseneer

Ok problem solved! It was showing that until I put in data. The sheet was blank so there was nothing to calculate.

FTesseneer

I made some changes and now I am getting Invalid Data Type

=IF([% Complete]@row = 1, "", NETWORKDAYS([Planned End]@row, TODAY()))

Freda

FTesseneer

Ok problem solved! It was showing that until I put in data. The sheet was blank so there was nothing to calculate.

Marcela

Glad you figured it out! Thank you for sharing your solution!