Hello! We use the star symbols as a column in our project schedule to show the status of the project. I need to create a chart that shows graphically these statuses but have been running into many issues. To help, I created a column in the schedule that is automatically populated with the number of stars for that row. Therefore, i have two options i could report on for 'Star Count'. The first is the symbol column itself, and the second is this number column that is automatically populated.
I created a report that holds all the names of the projects and their Star Count in number format. When creating a dashboard chart off this report, the chart would not populate. However if that Star Count field was not automated, and the numbers were manually updated, the dashboard would populate. Something in the automating the column of numbers would not allow it to be charted.
I found the same issue using a grid sheet. I pulled all the project names and used VLOOKUP to gather the number from the automated Star Count column. I was able to pull into a separate sheet the names of the projects, and their star count. However when i went to create a chart dashboard, the chart would not populate. I tested it with another automated number column i had set up and it worked with that one.
My column formula in the Star Count column is;
=IF([Status ]@row = "five", "5", IF([Status ]@row = "four", "4", IF([Status ]@row = "three", "3", IF([Status ]@row = "two", "2", IF([Status ]@row = "one", "1", "")))))
Thanks in advance!!
