I would like to display the Assignee(Contact field) of Successors. I currently use a Successor formula to successfully reveal which task rows are dependant. How can I also reveal who the next assignee of that task should be?
Trying to convert a drop down date to Date format, so I can program some automations off the date. Keep getting Invalid Data Type. My date column below is Date format the rest are all text. Can anyone see what I am missing?
Hello, I'm stumped on this formula and need assistance please! I am trying to populate Courses to Approve -Dean column based on the choice in the PC or Chair Approval Column. It works until I get to the "Some Courses Denied" choice in the PC or Chair Approval Column - which then is supposed to be taking the courses listed…
We have this formula to give us how many days are left for the Purchase order =-NETWORKDAY([Due Date: PO Ready]1150, TODAY()) But whenever I have today selected I get a negative -1 as Day Remaining Same happens when I select day after tommorow just gives me 2 as Days remaining How can I fix this? When the days are more or…
I am looking to determine if a value in a cell of a child is unique among the other children. Order Number | Items | Cost | Overall Unique | Order Unique | Total + 100 | | | 101 | Oranges | $1.00 | Yes | Yes | $1.00 102 | Apples | $2.00 | Yes | Yes | $2.00 103 | Bananas | $3.00 | Yes | Yes | $3.00 + 200 | | 204 | Pears |…
I am having an issue with this formula and need help :) I am wanting the formula to look at the "Lead CTC Region" column for Canada first (and pull in the "Lead AE" data with the INDEX/MATCH piece) THEN I want the formula to look at the "Lead CTC Global Region" column (and pull in the "Lead AE" data with the INDEX/MATCH…
I'm building a formula that uses the contents in a cell to effect a percentage. Basically: =(count all cells within a range with the word "PASS") (divide this number by) (All the cells within same range that are NOT blank ) The piece of the formula that looks at the row and avoids blank cells looks like this:…
Here is my nested IF formula and I don't understand where the issue lies. I've created a new column called [Initiative Expense] for my formula. My [Initiative Type] column has multiple values for types of expenses and credits, but if the value is one of five expenses (listed in parenthesis in the formula), then I want the…
Hello! I have a sheet that lists project milestones with a column for the milestone's due date and another column that I want to automatically assign the quarter that that due date falls in (Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec, and Q5 - which represents the "current" quarter but next year). Then there are projections…
Allow a Cell formula to be changed to a Column Formula when an $ (absolute references) is specified in the formula.