-
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…
-
Count days between start date and today
I want to count the days between the start date and today if the end date is blank.
-
Average formula
I am sure this is rather obvious, however I am not seeing where my mistake is. All I am trying to do is return the average cost of a product cost column but I need to not include any $0.00 dollar amounts that are populating (which will happen when there is no inventory at the moment). Can someone please advise where my…