-
Multiple IF/AND Statements
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 field values would be Ops, G1, NG2, G2, and Full depending on various criteria. Here is the logical expression: If [Tshirt]=…
-
How do i write the following formula
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 within five working days = Green IF the status is In Progress and the planned end date is today or with in three working days =…
-
Sheet ownership was transferred without a request
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 the sheet level that were shared at the work space level. When I did this it removed their access from the entire workspace.…
-
Counts of values in a multi-select column
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 count/total individual the types of contract types.
-
updating cells without loosing easy overview of historic data - how to?
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 for 3 item Y, 0 item X and in March pay for 1 item X, 3 item Y. Q1: Is it possible to have the customer update this…
-
IF OR AND Statement
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" Here is the code =IF([Date Completed]1 > 0,IF(AND(NOT(Completed1 = "Yes"),[Date Completed]1 > DATE(2020, 3,…
-
Is there a way to stop 100% completed tasks still showing in Resource Views
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 marked 100% complete they would no longer show/contribute to the loading of that resource. If a completed task dropped off the…
-
why when I remove a person at a sheet level is their permissions removed from the workspace level?
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 ? When I removed my co-worker at the sheet sharing level they were removed from the entire workspace.
-
Trouble with RGYB and blank dates
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 there are no dates, it looks as if all the tasks are delayed. (see pic) I would like: Green if complete Yellow in in progress…
-
COUNTIFS Cross Sheet: 1 Column is blank and 1 Column is not blank
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, but only if another column has text. I'm using this formula: Where Range 1 will indicate if a new submission has been…
