-
Help with formulas to drive Harvey Ball Status
Hello! I am trying to automate the Harvey Ball (R, A, G, Gray) status indicator on my project plan sheet. I am very new to formulas and am not sure what I am doing wrong. Below is a screenshot of the implicated Columns: The values in Status are: Not Started, In Progress, Complete. Harvey Balls are in Health: Green, Yellow,…
-
Counting by Number of files scheduled to go live EACH month. Creating a smartsheet summary.
I have a Target Complete Date for each type of file (over 1600) I need to capture the number of files Due to complete in Jan, Feb, etc Each month. I need to report each month on a summary report separately. Below I am trying to count IF any Applied Bank Files are due to complete in January. The first off sheet reference is…
-
CountIF with Criteria including date range
Hello, I'm currently trying to create a countifs formula to count the number of "issue type"(column) "story" where it meets certain criteria including falling within the next 30 days. My base formula works here: =COUNTIFS([Issue Type]:[Issue Type], "Story", Labels:Labels, "Groomed", Status:Status, "To Do") However, when I…
-
Automatic update to count values within a specific month
Hi, I currently use a countifs formula to count the number of met criteria within a given month. Data is entered monthly through a form. What formula can I use to automatically update the month automatically? The below formula works, but I have to manually enter the first and last day of the month in its respective column.…
-
SUMIFS/COUNTIFS Function: Total values but filtering out particular Status' AND Dates (Years)
Hi All, Firstly, I'll be honest and say I'm unsure whether this is a COUNTIFS or SUMIFS function but leaning towards the SUMIFS function based on my understanding of it. I'm trying to run a report to show the numner of (Column: Status) Closed Won and Closed Lost opportunities and the (Column name: Value) total value of…
-
Managing Testing with Automation Waterfall Notification and Showing Status with RYGB Balls
I have spent some time looking for solutions to my specific need but have been unsuccessful to find anything that fits right, although there were lots of good suggestions that I tried (and couldn't make it work). We are migrating servers from one location to another and we have multiple IT groups that need to test the…
-
Tooltip popping up making drop down list hard to choose from
As you can see in this image, when the user of this sheet attempts to select a value from the dropdown in the first column, a tool tip pops up interfering with the ability to update the column. Its not stopping the update but just makes it take a little longer. Is there any way to disable this popup? Maybe its a…
-
If Start & Finish date lies in the current year then reflect the value in column "X", row "Y"
See diagramed questions in: RED: IF Start & Finish date lies in the current year then reflect the value in column "X", row "Y". GREEN: When % complete value turns 100% then reflect the value in column "X", row "Y". PURPLE: Conversely IF Start & Finish date lies in the next year then reflect the value in column "X", row…
-
Help with a SUMIF statement but it gives me UNPARSEABLE
I have the following SUMIF statement on the top row of the column - =SUMIF([Plate Size]:[Plate Size], "57""", [# of Plates Made]:[# of Plates Made]) If I change it to the following it works but the problem with this is I have rows that do not have data in them yet and I am not sure if it calculates the newly added data if…
-
Countifs help
Good day all. This is most likely a very easy question for someone as I'm having a brain cramp on this. I can't seem to figure out what is missing from the following simple formula: =COUNTIFS([Start Date]:[Start Date], <TODAY(), Status:Status, "Not Started") The formula is for task roll-up sheet for items that are late as…