I’m trying to do something in Google Sheets, and have been unable to get it to work.
If anyone can help/show off their spreadsheet skills, I would be very grateful.
I’ve made a demo spreadsheet to show you what I mean without revealing my data:
I want the big merged cell in D and E columns to show the date at which the expected progress column first gets to 100.
In my real spreadsheet I have other data and factors which controls the progress percentage, and it is often changing.
Getting the expected completion date in that big cell should be easy, but I have been unable to get it working. Many thanks to those that can solve this issue
I think chatGPT might have solved it. Let me try and implement the solution
Who is this ChatGPT guy, they seem to know everything?