Forum Discussion
Help with challenging formula
Hello! I need help figuring out how to get a formula to work and was counting on this community's expertise! I basically have a table with ticket items where one of the columns for each ticket i...
I get that the table gets overwritten each time, but the helper column could be on a completely different sheet/tab. That said, I'm sure there is some way to make it into a single formula, it would just take some time for me to figure it out (others here may do it much faster)
Thanks, mtarler.
Yeah, I understand the suggestion but I'd have to manually create a user column for every new sprint, which defeats the purpose of making it automated. Besides, wherever those columns would sit within the spreadsheet, imagine having dozens of helper columns there that keep growing indefinitely - especially because the spreadsheet is already pretty large.
I can't believe the formula was so easily created in Google Sheets thou. Hopefully, I'll find an equivalent single formula in Excel like I had in Google Sheets...
Yeah, I understand the suggestion but I'd have to manually create a user column for every new sprint, which defeats the purpose of making it automated. Besides, wherever those columns would sit within the spreadsheet, imagine having dozens of helper columns there that keep growing indefinitely - especially because the spreadsheet is already pretty large.
I can't believe the formula was so easily created in Google Sheets thou. Hopefully, I'll find an equivalent single formula in Excel like I had in Google Sheets...