-
Aggregate Red, Yellow, Green Status to One Overall Grade
Good day, I am looking to Aggregate Red/Yellow/Green status into one overall R/Y/G. Here is the criteria for grade 1: All classes are either yellow, or green, overall grade = green 3 classes at yellow, overall grade = yellow Any one class at red, overall grade = red Here is what I have tried, =IF(AND([Grade]@row = "1",…
-
Formula on Metrics Sheet all Zeros until I open the sheet
This formula works perfectly fine but for some reason it defaults to 0 until I actually open the metrics page. I use this metric in a dashboard and everyday it changes back to 0 until I open the metrics page. Can someone explain why? =COUNTIFS({supervisorDOT}, [Primary Column]@row, {completedDOT}, 0) I even created…
-
Help with Ancestors forumla to show Parent Row information
Hello Smartsheet Community Stuck with using Ancestors based formula to do the following: In the process of building a sheet to roll up task and eventutally project information so that as we decompose/create more children from the parent row, the parent task from the parent row shows up under the parent task column. So in…
-
Creating Formula from a linked sheet
Need Help. I have two sheets- Sheet1, has all the Survey Values (i.e, Yes, No, NA), and Sheet2 will have all the Formula. I want to assign a numerical value on the answers of Sheet1. For instance, Yes= 15, No= 0, N/A =0, and have them all populate in Sheet 2. So here is my formula in Sheet2 =IF({Sheet1} = "Yes", 15,…
-
If statement based on date paired with Smartsheet Symbol
I have a sheet that lists due dates in one column, and I was wondering if there is a way to use an If/then statement within the symbol column to indicate the following: If the due date is within last 12 months, the symbol is green If the due date is between last 12-18 months, the symbol is yellow If the due date is longer…
-
Need the Date of the beginning of the week.
how do I create a Week of Date based on dates during the week? For example the Delivery date of 10/21 I want populate the Week Delivery Date with the week number Date. Do I need to create and additional week number column or is there a formula I can use?
-
IF formula stops referencing columns after a certain point unless I manually type
I have a survey going to to people with 56 compliance rules. When the survey answers as "out of compliance" I have a rules column for each rule change that to a "1". Another column I've made have multiple selection options with the rule number and compliance issue. So Ideally when someone answers "out of compliance for…
-
% Complete showing effort is late when it is on schedule
I have a set of tasks that are currently on-track, but the % Complete is calculating only at 9%. When I do a manual check I find that I am 30% into the effort and 26.25 complete. Why is the % Complete showing only 9%?
-
Index Collect - Pulling from one matrix to another.
Whoops! It posted without text. LOL I've got data that's in a matrix. With Date on the left, and the Product Name in a helper row at the top. I have an entry form with this layout, and an output form with the exact layout. I need to match the Date/product to pull the value from the entry form, into a formula in the output…
-
Setup of summary sheet to graph for dashboard
I currently have a master sheet where we gather weekly data. You can see in the photo that I have helper columns for year and week. These entries are individuals. The other important columns are the Pack name and total columns. Master sheet What i need to do is to create a summary sheet that will total the points by "Pack"…
