I wonder if anyone can help me. I hope what I'm trying to do is quite simple and I've just not been able to work it out.
High level, I want to work out what stage a project is currently at based on the % complete of certain tasks in the project. I have setup project templates, so I know that all of the task names are going to be consistent throughout the projects. I was hoping to use a custom field to do doing something along the following lines:
IF(In($PercentCompleted < 100, $Name = 'Welcome Meeting'), 'Waiting Welcome Meeting', IF(In($PercentCompleted < 100, $Name = 'Scoping Meeting'), 'Waiting Scoping Meeting', 'Next Stage etc'))
But then would carry on based on what the task it is and what I want the text to be. I then want to display that on the Project Property Card as an overall project level stage.
Is this something that can be easily achieved? I've had a few attempts at it and done some searching of the knowledge base and previous community posts but haven't been able to find a solution. Not sure if a Project level custom field has a way of seeing a Task level item? I know why when I setup a Project custom field if I use $Name I presume it's picking the Project Name and not the Task Name, does anyone know if there is a syntax I can use to pull back the Task Name?