Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

if statement help

Hi  I am trying to use the below formula but it is not working  Projects Status = if(Tasks[TaskName]=RELATED(TaskBaselines[ProjectName]),IF(Tasks[Progress]=100,"Completed",IF(Tasks[Progress]=0,"NO...
if statement
Need Help
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

Ive got no idea how you statement works, but I see an error -missed closed parenthesys ")" after "In progress"

 

if(Tasks[TaskName]=RELATED(TaskBaselines[ProjectName]),IF(Tasks[Progress]=100,"Completed",IF(Tasks[Progress]=0,"NOT Started","In Progress") ) ,""))