-
Looking for help with this formula.
=IF(AND(C4="Freeway/Interstate",C2="Major Residential"),"325"),IF(AND(C4="Freeway/Interstate",C2="Commercial"),"132"),IF(AND(C4="Arterial/Collector Street",C2="Major Residential"),"75"),IF(And(C4="Arterial/Collector Street",C2="Commercial"),"50")) Should translate as: If C4 = "Freeway/Interstate" AND C2 = "Major…
-
Formula to Count filtered data (COUNTIFS?)
I am trying to count how many items in Column1 are "High" priority but do not have a value in Column2 of "Closed" or "Withdrawn". =COUNTIFS(Column1:Column1, "High", Column2:Column2, "Closed") tells me how many are closed - but how do I find out how many are not closed AND not withdrawn? Any ideas are greatly appreciated.
-
SUMIFS within Date Range
Hi, I need help creating a formula to summarize an average using Sheet Summary Columns, I have the following sheet columns: Current Date, Average Rating, I have the following summary columns: From Date, To Date I have the following sheet summary column (locked) for our formula: Total Average Rating I'm trying that the From…
-
Update parent row status based on the children status
I am using the formula below to update the status of a parent row based on the children's status, but when all statuses are blank, it is showing the parent as "Complete". I need it to show as "Not Started" if all children are blank. =IF(COUNTIF(CHILDREN(Status@row), "In Progress") > 0, "In Progress",…
-
Count the number of times values appear in a multiselect column - depending on a value in other cell
I want to count the number of times values appear in a multiselect column with the condition of a value appearing in a different cell . for example: we have a fruit multiselect column and day of the week when we bought the fruits. I want to count how many times apple appears in a fruit multi select column that we bought on…
-
COUNTIFS Blank & Not Blank
Hello, Formula shouldn't be too difficult, but I'm having some issues. What is the syntax for a function that counts is a cell is blank within certain criteria. Here was my attempt, but it was not working. Will also need the notblank version. =COUNTIFS({Domain}, [Primary Column]@row, {Metric}, ISBLANK({Metric})) Thank you!
-
Two new PPM Functions: Successors and isCritical, available now!
Hi Community, We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical. The Successors function (type: numeric) allows users to calculate the direct successors of a task and return a collection of values that will occur as a result of the referenced task.…
-
Formula for task health
I am looking for a formula to identify task heath, based on duration, % complete and target due date, where the health is based on duration of task, such as 5d and if there is enough time to complete the task and the %completed - so a 10d task that is more than 10d before target date would be green. That same task would…
-
Want to have contact list automated by "last modified".
Good afternoon everyone, Seems like a simple formula, but I'm having some issues figuring it out. Essentially, I want to have a "contact list" column automated by a "last modified by" column. Example: If Dan Tanner modifies a row, the "last modified" would be "dantanner@email.com" and that would trigger the "contact"…
-
Reference another sheet
Hello, I would like reference another sheet but the sheet reference name remained the same. I would like reference into the Sheet Master but its blocked toanother sheet. You can see in the print screen Thanks to help me
