I recently purchased the project management dashboard which is great. I have been able to tailor it so far and use it within our business.
By changing the project status in the data tab to either Red, amber of green via the drop down option, it changes the dot status colour on the dashboard. How does this work? I want to add another row in the data tab called last weeks status so that there are two dot colours on the dashboard.
I have tried looking everywhere for formula but cant work it out
By changing the project status in the data tab to either Red, amber of green via the drop down option, it changes the dot status colour on the dashboard. How does this work? I want to add another row in the data tab called last weeks status so that there are two dot colours on the dashboard.
I have tried looking everywhere for formula but cant work it out