-
Complex COUNTIFS and IF Function
Hello, I need help putting together a function that can count certain cells in my grid. The inputs of the function are the following: If Beta is "Yes", it should be counted twice If Beta is "No", it should be counted once But if the Primary Region Column is not checked, the row should not be counted at all. Beta is a…
-
Need to Count Unique Values Based on Criteria from a DropDown Collumn
Hello, I need a function that can identity duplicates and determine if they should be counted as one or more than one depending on criteria within another column of the spreadsheet that is a dropdown. The specific context is there is a Name Column (Column A) and a Dropdown Column (Column B), Column B has three options "Yes…
-
Help with RYG IF Statement and consider a Blank Cell
I have a sheet to measure KPI's for a project. Bascially I'm trying to record when we submit a report; If the Submission Date falls before the 4 Week Limit (Purple Helper Column) KPI 2 returns Green If the Submission Date lands after the 4 week limit but less than 14 days 'late' KPI 2 returns Yellow If the Submissinon Date…
-
#BLOCKED on Dashboards
Hi Community! I have built a data visualization dashboard that runs off a "summary" sheet. The summary sheet is all formulas that average data from a master sheet. My problem is, instead of the Dashboard updating live based on the data in the summary sheet, it breaks and shows #BLOCKED every time the master sheet updates.…
-
INDEX from another sheet's multi-contact column
Hi, I have a "Project Master" sheet that lists all our projects and has a multi-contact column where I keep all the resources (contacts) that are working on each project. On a set of other sheets, I am trying to collect and index the set of projects to which a single resource is assigned (and I need that to be a metric…
-
Formula assistance
Hi, I currently have a sheet set up where I am calculating the total revenue generated for all the tasks listed underneath the main header using the =SUM(CHILDREN()) formula. All the tasks listed underneath the header in the status column is being classified as awarded, cancelled, pending and unsuccessful as shown in the…
-
Why does this formula not work today?
=DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) - WEEKDAY(TODAY())) It is the Weekday part of the formula that is stopping it from running. Using INT and VALUE and whatever else I can think of doesn't work. @Genevieve P
-
Parent function to auto-populate cells
Hi everyone, Wondering if someone could help me with a formula to auto-label cells. I'm creating a project tracker for my team on Smartsheet and have automation set up for approval process, and also so completed tasks are moved to a new sheet. The problem is, on both instances, the row itself might not contain all…
-
Formula to paste values generated by function
I'm trying to figure out an automatic way to run a function in a cell, and have that function paste the value, and only the value, to that cell. I don't want the formula to continue to exist within the cell. Similar to if I copied the cells post calculation, and did a paste-special of only the values. For example, =5+3…
-
IF formula for RYG balls
Hi I am trying to make a formula that states: If it is 14 days past the TBF date field, and the Reported date field is blank, make the ball Red. If it is 7 days past the TBF date field, and the Reported date field is blank, make the ball Yellow. If the Reported date field is NOT blank, make the ball Green. Nothing I try…