-
Getting Invalid Data Type when trying to use Date() formula
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?
-
Help with Join/Collect and Has and Not/Has formula
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…
-
Network Day giving negative number for the same day
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…
-
Find unique value in Children
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 |…
-
Issue with nested IF formula looking at the 1st column THEN 2nd column (to feed INDEX/MATCH data)
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…
-
Not counting based on multiple factors
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:…
-
How to fix #UNPARSEABLE for my nested IF formula
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…
-
Formula to correctly assign a quarter (e.g. Oct-Dec) to a due date
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 $ (absolute references) in Column Formulas
Allow a Cell formula to be changed to a Column Formula when an $ (absolute references) is specified in the formula.
-
IF Function to Add Quarter and Year
Hello, I am editing a smartsheet that tracks tasks. I have a column for the quarter that needs the year based off [End Date]@row for all tasks added after the calculated quarter. I am using the formula: =IF(ISDATE([End Date]1), IF(MONTH([End Date]1) <= 3, "Q1", IF(MONTH([End Date]1) <= 6, "Q2", IF(MONTH([End Date]1) <= 9,…
