Hey there,
I'm new to google sheets and I've got in a bit over my head I think. I've designed a working (until now) website backed up by an embedded google sheets system to update user accounts and account balances. All my boss wanted was a basic chart for each account to show the rise and fall of balances. I went in and just tried to figure out on my own how to do that.. so definitely I may have made some errors in the setup. Anyway.. all seemed to work fine for a few weeks until today when I tried to input new data from the current date.. (or any future date) these changes simply would not be reflected in the linked graphed data as usual. What's bizarre is that if I change the input date to anything before 12/8/21 everything is plotted in the graph fine. As soon as I exceed this date in time it refuses to plot any data. (*Please see attached screen shots for what I mean.) The date is the only entry I am altering so I know it has something to do with that. But god knows what.. EVEN more bizarre is that I have another identical client page set up where everything works perfectly regardless of the date input with the same dates and exact same settings only no issues.. yet 99% of other accounts have the same issue I describe. I cannot figure it out for the life of me. Anyway my boss has been less than forgiving and told me I have 48hrs to figure out how to get the correct dates in there or he'll replace me and find someone else who can make a basic spreadsheet etc.. Maybe I am just doing something stupid but none of it makes any logical sense to me.
**EDIT: Something of note is that when I try to "clear formatting" for the entire "Date" column anything with the dates above 12/8/21 do not return to an original non formatted state and and centred opposite to the other entries... may not be relevant but.. very weird.
Anyway if ANYONE can help at all or give me any clue as to why this hell might be happening I will be forever indebted. I've tried everything.
- Dan
example1.png example1b.png
Bookmarks