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…
Hello! I am working with a Health column that refers to our Status column and start/end dates. I have a formula that is working once the dates are entered, but when I use a fresh templated sheet and t…
Hello, I'm doing a master summary metrics sheet (in lieu of a summary sheet on the source sheet because I need to build graph charts in a dashboard). I need to count blank cells in a specific column, …
I have a summary sheet "Summary Sales" created from another sheet "ADMIN_2020" in rows 2, 3 and 4 of the "Summary Sales" I have 3 employees assigned. And I need to do the sum of the entire column (NET…
