So my supervisor has a request that I struggling to find a formula for. We have the following columns that need to interact with each other.
- Start Date (Date and Time)
- Progress (Dropdown)
- Stage (Radio Button)
- Est. Deployment (Date and Time)
If you have suggestions on how to clean it up to connect better PLEASE let me know.
Now what they want, the best way I can describe, is the following:
- Stage has three buttons (Development, Review, Testing). They want that to be green and change color to Red after one week if it has not changed. So when it is updated to one of the other selections, it goes back to green.
- Start Date talks to Progress. There does not need to be a starting green. Progress has 4 selections (Ticket, Use Case, Form, Ready). Ticket should only be around for 3 days before turning red. Use Case 2 weeks until red. Form 5 weeks until red. Ready means its done.
- Est. Deployment. We usually time this 2 months out from the creation of the ticket (Start Date). My supervisor would like it to change color based on time passed, but if the Progress turns red at any point, it changes to color of the Est. Deployment to show if we are on schedule...
I have very very base knowledge of JSON. Honestly, I would just take an answer if this is even possible. I have been looking at different tutorials and questions that circled around some of these, but we have never done anything this specific for our dashboards. Any help is welcome, even a recommendation on what would work better? In the end it has to wind up on sharepoint somehow.
