Hello, this is my document I've been working on for organization and tracking progress at work. I'm a beginner and I'm happy to have gotten it functional but I'm hitting a dead end with regards to some quality of life improvements I'd like to make. I don't know much about the formatting language and have been doing lots googling and trying to find commands that work but I'm having trouble translating them into my use. I have no experience with scrips or addons so they're likely to go above my head and I may be out of luck if there's no way to do these things naturally.
This will eventually be displayed on a screen in our workshop so I'm trying to find ways to make it as visually telling as possible.
https://docs.google.com/spreadsheets/d/1ffZT43S1lZxX_C8TfPziSGuORCRu8UptUpXCQwC4954/edit?usp=sharing
The things I would like to do include:
1 - Have checkbox in F only appear for some dropdown choices in E (AFO, AFOS, KAFO, KAFOS, UEO) I'm doing this by hand right now which is fine but it would be nice to have.
2 - Have a FALSE checkbox in F change colour as date in C approaches (darker red 2 weeks in advance).
3 - Sort table by Clinician (D) in separate tabs, with formatting.
I've seen that Sheets can't create a checkbox based on formatting and that this type of request requires a workaround involving making the text the same colour of the background but I'm having issues making it work based on a dropdown selection. Like I said I'm not well versed in the way formatting works and I'm finding it hard to string together different conditions and having it still be functional.
I hope that's all the information I can give, if there's anything else needed let me know and thanks for any help!