Reply To: Automated process to check if a Resource has a unique calendar

[Ismet Kocaman]

Michael,

Please try this:
iif ( ProjDateDiff( [Project Start];[Project Finish];[Name]) <> ProjDateDiff( [Project Start];[Project Finish];[Project Calendar]); “Resource Calendar Prepared”; “Resource Calendar NOT Prepared” )

The #ERROR situation is just because both Start and Finish hold NA for an unassigned resource. You can use [Base Calendar] instead of [Project Calendar], depending on the calendar use for resources.

Regards,
Ismet | ikocaman.pm[at]gmail.com