Forum Discussion
Formula creation using multiple lists and tabs
Hi All, I've created a data sheet to track my organisations work in hours across a variety of different work streams and activities. In doing so I have incorporated numerous pick lists that inclu...
Hi Jalinio,
Just for the context, if you use SUM in the column G in the "Delivery Formulas" sheet, the SUM should add all the values in a row.
Just universal formula, no matter the case, i.e. SUM(B12:F12).
Wouldn't that be okay?
Best Regards,
M
Hi MarekBernolak
Thanks for the response.
I had already done this on the second picture shown. But I now want to create another formula (in a separate tab - identified in picture 1 main tab 'project tracker') that identifies the outcome of that formula based on what items are picked in the drop lists created from the other tabs if that makes sense?
Kind Regards