-
Issue with SumIFS
Hi, I am trying to get the sum of Green Communities eligible projects in a fiscal Year. What I have for a formula is: =SUMIFS([Fiscal Year]:[Fiscal Year], "FY23", [Estimated Acquisition Cost]:[Estimated Acquisition Cost], >0, [Grant Name]:[Grant Name], "Green Communities") And this is throwing a Incorrect Argument set. Any…
-
Networkdays between a date and today
=NETWORKDAYS([date to vendor]1, [today], [holidays]) Help! I need to calculate the number of days since a date and today excluding holidays. Thank you!
-
Changing Color Symbols by Number of Days from Due Date
I'm trying to show the risk of a project running off of today's date compared to due date. Here is the criteria: If less than or equal to 3 days to due date from today color Red. If greater than 3 days but less than 8 days to due date from today color Yellow. If greater than or equal to 8 days to due date from today color…
-
Unparseable Formula
Can anyone see something obvious that is causing this formula to throw an "unparseable" error? =IF(AND(Status4 = "Not Started", [Workdays since Start Date]4 < 0), "Green", IF(AND(Status4 = "Not Started", [Workdays since Start Date]4 > 0), "Red", IF((AND)Status4 = "In Progress", [Workdays since Start Date]4 < 0), "Green",…
-
Check Parent box if Child box is checked
I have a column of checkboxes and would like to check the Parent box if any of the children boxes are checked. What's the formula to do that?
-
Alternating contacts
Hi, I'm trying to see if I can assigned alternating contacts for rows for some children rows. What I would love to do is find a way to reference the last children row contact from one location and then start off with the other but I'm having a bit of a struggle. Initially my plan was to create some auto generated system…
-
Weeknumber formula help
I want to count all instances in a weeknumber, but the formula I'm thinking to use is not working and is returning #INVALID DATA TYPE. The 4 is the week number I am looking to count all the instances in. The reference column is a Date format with nothing but dates in it, so I'm not sure what I am doing wrong, help.
-
List all unique values from a column within one Smartsheet in a separate Smartsheet
Hi All, In my Smartsheet I have a column for Workstream - each row (deliverable) in the Smartsheet has a Workstream - there could be one or numerous Workstreams. In a seperate Smartsheet, I want to be able to pull all Unique values from the Workstream Smartsheet. In Excel I would simply do something like -…
-
Past Due, 1 to 30 days , 31 to 60 days & 61 to 90 days
Hi Team, I have a "Planned start date" column , I need data for Past Due, 1 to 30 days , 31 to 60 days & 61 to 90 days in once cell, could you help. =IF(TODAY() > [Planned Start Date]@row, "Past Due", IF([Planned Start Date]@row <= TODAY(1-30), "Start < 30 Days")) Out comes : "Past Due" "Start < 30 Days" "Start between 31…
-
INDEX, MATCH, MAX with extra criteria
Good Morning, I´m struggling with a formula that can show the name of the person with the MAX value with the condition of an extra column For the rows considered I'd like to get the name of the person with the max score (Example, Alice) I´ve tried INDEX, MATCH, MAX but I haven´t been able to add the criteria of the…