-
Individual formula editing changes the whole column
Not sure if this is supposed to happen, but since i was not expecting it at all, i found it extremely frustrating. So i have a spreadsheet that is using several index/match formulas on different columns to pull information from other spreadsheets. But today, one of the Admins on another spreadsheet made me aware that he…
-
sumif multiple criteria
Hi, I can figure out the sumif for the current week but I would like to add another criteria. I keep getting an error could someone help assist =SUMIFS({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}, {Work Type}, @cell= "Budget") Thanks
-
Auto populate score based on 6 different criteria zones.
Hello, I have been asked to build a scorecard that would automatically insert a numerical score (0-5) based on the input given. So for example, if a perfect score of 100 = 5; 90 - 99 = 4; 80 - 89 = 3; 70 - 79 = 2; 60 - 69 = 1; and 0 - 59 = 0, I would like to develop a formula that would automatically insert the correct…
-
Predecessor formula Help
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all…
-
Calculating Time
Hi, I know Smartsheet is "working" on time stamps, but I need a little help. I am trying to calculate 2 different time scenarios. First is from the time a work order is opened to the time its is dispatched. Second is the time from the open date to completed date. You will see on my sheet, the "open to dispatch" time in…
-
Trying to create an IF THEN function in smartsheet
My example is to select an material size value based on the material. Something like this: If [cell1]="4X8 Sheet" then [cell2]=32, if [cell1]="4X12 Sheet" then [cell2]=48, etc, etc. I have a dropdown list in the materials column to restrict the set of possible materials. Subsequently, I would like to take those values to…
-
Sum if of Current Week +/- 1
I have a formula that will give me the current week capacity: =SUMIF(@{Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}). However I'm not sure of the formula to capacity for the next week or the past week capacity =SUMIF(@{Week Number}, @cell = (WEEKNUMBER(TODAY()) +7), {Capacity}). I would greatly appreciate some…
-
Nested IF statement with Checkbox
I have 3 fields. 2 fields are checkboxes and 1 is text. Active (checkbox) Not Active (checkbox) Complete (Yes/No) I want to write a nested IF statement that if either are checked it provides a Yes / No response. IF(ACTIVE = TRUE, "Yes", IF(OR(NOT ACTIVE = TRUE, "Yes", "No"))) I get the field to work how I want for Active…
-
Find a Match withing a Join?
How can I use MATCH to find if an instance occurs within a group of values joined with JOIN? For example, if I join the values in three columns (Red Yellow Blue), no commas just a space, and I want to MATCH the value in a cell (say, "Red"), how can I see if the joined values (Red Yellow Blue) contains Red? Right now, the…
-
Dashboard formula counting rows within date range
First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. =COUNTIFS({FAMS Marketing…