-
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…
-
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…
-
Need to count tasks with due date past due AND complete box not checked
I am new to smartsheet and trying to create a master summary sheet referencing a huge sheet with 1600 files. I need to count "by file name" how many tasks are 1. late < 1 week 2. late >1 week < 3 months 3. late >3 months There are columns for FILE NAME, Due Date, and a Box to check when completed. So I need to say if this…
-
Advanced formula/function question.....
I am trying to write a complicated "if" function to search text and provide me with a result if any of the words in quotes are found in the text string. The formula works in excel but I cannot figure out how to replicate it in Smartsheet. Is there someone that can help? This is an example of the formula as it is written in…
