-
Formula referencing data is returning off by 1 week
Hey there, I'm currently using the below formula to pull in and report the availability of our consultants on a per week basis. The formula sits in a Smartsheet that references another Smartsheet where the data is in two columns from a start date to an end date every week that Consultant is booked. The Smartsheet utilizing…
-
Struggling with SUMIFS
I am trying to use SUMIFS to total a column from another sheet ({Recap Total Range 3}) with the following 3 criteria - matches unit #, and between two dates, I continue to get either impearsable or incorrect argument and hoping for some help. =SUMIFS({Recap Total Range 3}, {Recap Total Range 2}, >=$[Start Date]$1, {Recap…
-
Automatic Move Row and External Sheet References
I am having issues with the Automatic move row function and external sheet references. It doesnt seem that the automation will trigger if the formula needs to look up a value from a different sheet. Proofing is not turn on for this sheet. See screenshot for the formula Automation: If cell= "a number", then move to another…
-
Automatically enter category into cell
Sorry, I do not know how to say this. I would like to see if there is a way to automatically enter the category name into a cell. (see image) I've manually put the category in the highlighted box but I'd like to see if there is a faster way? Thank you
-
SUMIFS to COLLECT DESCENDANTS
I am trying to rewrite some formulas in a large sheet due to the sheet crashing regularly. It is my opinion that the sheer mass of SUMIFS within this sheet is causing it. Here is my current formula: =SUMIFS($Actual:$Actual, $[Job Number]:$[Job Number], =$[Job Number]@row, $Department:$Department, ="Design",…
-
Formula Help
Can anyone help with this formula? It works in excel but I am getting Unparseable error in smartsheets. =IFERROR(IF([QTY]@row,<>0,[QTY]@row*[Production Rate]@row),IF([Linear Feet]@row<>0,[Linear Feet]@row/[Production Rate]@row,[Sqft]@row/[Production Rate]@row)),0) Thanks for any help
-
Nested IF Statements and RYGB balls
I have a status column that is being manually entered based on the days past due. I am trying to automate RYGB balls. I have gotten the equation to record what I want for Red and Green, however, I would like to have a blue one appear if the if the status is in queue. The problem I am running into is that the Days Past Due…
-
How do I get an unduplicated count of names from a cell range, filtered by date?
I am creating a sheet summary for a sheet that includes a column called "School Name" and another column called "Program Inclusion Date." Some of the schools are listed more than once in the "School Name" column, and I am trying to get an unduplicated count of school names with dates in the "Program Inclusion Date" column…
-
Alternating Row Colors
Hello, I am trying to format my entire sheet with colored rows that alternate. The Excel formula that perfomrms this is : =MOD(ROW(),2)=0 This would be an awesome feature but I can't seem to fiund anywhere in the UI. Thanks for your help.
-
MAX? IF(S)?
Hello! I'm trying to figure out a formula to return the highest value from a range as long as it matches certain criteria. In the screen shot's example-- I want (in column 'Highest Day Late') to return the value of the highest past due date based on the range only if it includes the name from the Primary Column. Please…