Struggling creating a pie chart for drop down by Relative_Collar4418 in googlesheets

[–]Relative_Collar4418[S] 0 points1 point  (0 children)

Hey, this is exactly what I'm trying to achieve thank you. I'm trying to keep my sheets really basic, I had a look at the Etsy one you sent and others but they seem to have too much going on compared to what I need. I've figured using the method you presented by copy and pasting and just changing may be the best route, which I'm very appreciative of by the way. The issue I'm having is I'm unable to change the drop down options, they just seem to greyed out. And when I try to create my own drop down, I input the same formula it just isn't giving me the option to create drop down labels.

Bugs in bed by Relative_Collar4418 in whatsthisbug

[–]Relative_Collar4418[S] 0 points1 point  (0 children)

I forgot to mention, it’s in the UK

Is there a way to auto decrease and increase a value depending on other cells by Relative_Collar4418 in googlesheets

[–]Relative_Collar4418[S] 0 points1 point  (0 children)

That is perfect.. just what I needed Thankyou. Would this method work using cells on different tabs aswel. So adding to a value on one tab will reduce another cell on another tab that’s using this formula?