I have a sheet where i am tracking multiple different tasks for completion. i am attempting to create an (Overall status) once a few key items are marked completed, and or box is checked. Can someone …
Hoping someone can assist me with a formula. I've spent quite a bit of time trying to figure it out on my own and can't seem to get it. I have multiple criteria to determine the value of a field. The …
I am trying to write a If-nested formulas that works out the following. What i am trying to say with this formula is the following: IF the status is Complete and the planned end date is today or withi…
I believe there was a side effect to a mistake I did. Our structure is one workspace for all of our projects, with each project in a separate folder. I mistakenly removed sharing of my coworkers at th…
I'm trying to count the number of values in column that allows for multi-select. In this case, column is Contract Type - and the request can involve multiple contract types...I'd like to be able to co…
We have a list of customers, where the invoice changes from month to month according to use of specific items. Example: Customer A will in January pay for 2 item Y, 0 zero item X, and in February pay …
I am trying to return color symbols for in a sheet. End goal Date Null, Completed Null, or Past DATE(2020, 3, 31) = "Red" Date is Not "Yes" and Not Past DATE(2020, 3, 31) = "Yellow" Else = "Green" Her…
We use Resource Views to show capacity loading for each department in our factory. Not sure if this is possible, but it would make sense to me if when tasks allocated to a particular resource were mar…
My co-worker are both admins at the workspace level (which allows access to all of the workspace). How can I remove my co-worker just at the sheet level to avoid aerts to every one shared to the sheet…