Home › Forums › Discussion › Automated process to check if a Resource has a unique calendar › Reply To: Automated process to check if a Resource has a unique calendar
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