-
Formula for In Progress and Yellow OR Green health
Hello, I am wanting a formula that shows me all of the "In Progress" items that have a health of either Green or yellow. I can get the formula with just the Green, but not sure how to add the OR "Yellow" part of the formula. =COUNTIFS({Project: VCLC Needs Assessment Range 2}, "In Progress", {Project: VCLC Needs Assessment…
-
Returning Start and End Dates
Hi All, I am trying to get the MIN or start date of a range that only grabs from the row with the same phase. Keep in mind these Start and End dates in the project plan below have dependencies enabled. I would like to return the MIN Start date in the Start Date Metrics column row 3 in image 1. The range is the Actual /…
-
How to SUMIF(S) Date Range
I have been trying to sum the total length of contacts within a date range and I can't figure out how to make it work. I have been successful summing have of the problem, but can't seen to find a way to make them work together: =SUMIF(CHILDREN([Date Start]58), >=[Date Start]4, CHILDREN([Length of Contact]58))…
-
Automating count formula and trend summary
Hello All, I am wondering if there is a way to automate this process. I am trying to get a count of each line item status type at the end of each day. Currently, I am updating a master sheet that has a status column reading either “active” or “not active.” At the end of each day, I am manually totaling the number of active…
-
Roundup
I am looking for a formula that if a number in the "adders" column is negative, round to zero and if the number is positive, roundup to the nearest 1. Example: -7.03 need this to round to 0 7.89 need this to round to 8 7.05 need this to round to 8 Thanks!
-
Counting cells with numer of %
Hi i want to count the number of cells with 100% i.e i have 20 projects that have reached 100%. i tried =COUNTIF([% Complete]1:[% Complete]118, (100)) and also tried =COUNTIF([% Complete]1:[% Complete]118, "100") but it doesnt return the correct number. Thanks Paul
-
Dynamic view comments
Hi All, I have noticed that there is no way of seeing if there are new comments, or any comments at all in dynamic view ( the main view display). In fact, come to think of it an "unread comment" marker against a row in normal sheets would also be helpful. When setting up the dynamic view, " display comments" is an option,…
-
IF condition statement from multiple columns & properties
Need help populating the right color in my status column, which uses Red, Yellow, Green circle symbols depending on what other columns are reporting. I assume the below could be written with a formula. IF column B is blank, then RED. IF column B is not blank, then Yellow. IF column C is checked, then Green.
-
General Dashboard and Widget Question - Moving Groups of Widgets
Is there a way to move multiple Dashboard elements or widgets all at once? I'm finding that I have several "metric" widgets on my dashboard and currently I haven't found a way to "select all" and move them as a group. Instead I am currently having to move all of these widgets manually one at a time which can be tedious -…
-
RYG Milestone AND All Other Tasks
Hello - I have a team project plan that consists of 1) milestone tasks, and 2) all other tasks. There is a column ("Milestone') that is a checkbox that denotes if it is a milestone task if checked. At the bottom of the Smartsheet, I want to have a milestone summary that reports the following: Milestone task - If at least,…
