With the little knowledge I have with spreadsheets and with lots of help from Google, I've managed to create this little project management spreadsheet to help me tracking stuff and it works pretty nice so far. To keep it clean, I've put the services pricing on separate sheet. All nice and crisp so far.
At this point I've managed to auto-populate the services names into the Projects sheet (column C) with the services names I have on Pricing sheet via Data validation.
But... the formulas I've used are pretty long and messy, quite hard to update when I'm gonna add new services. And with every service added it's gonna become even longer and messier. Is there any way to clean those formulas on columns G and J and use something easier to update? Or maybe auto-update them somehow like the C column is updating?
What I'm thinking of is something like FOREACH sort of function, or something like that, and that will have to check all 3 columns (C, G and J) while making the calculations, but to be honest I have no idea ho to do it, or even what to Google for or, even even more, if that's a solution for this.
So... any ideas and/or help is greatly appreciated.
Thank you.
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 193
تاريخ: دوشنبه
17 خرداد
1395 ساعت: 6:14