-
Material Tracking
Please help haha It is difficult to put into words exactly what I am trying to accomplish, but I'll do my best. Please ask questions if I'm not being clear enough. Example: I have a material column for material that is being delivered to a job site (Sheet name is Delivery Tracker). Each cell in the column is an individual…
-
Can you use an "IF" function with a dropdown?
I have a dropdown list in one column with 5 options to select. I want a Text/Number column to produce a designated value based on the option selected from the dropdown: Dropdown contains : Project, Small Project, etc. Values would be Project = 10, Small Project = 9 Every attempt tells me #UNPARSEABLE. What am I doing wrong?
-
How do I extract the values from a multi-select dropdown?
I am trying to count values from multi-select dropdown. We asked how many check-ins people would like to have: 1/year, 2x/year, 4x/year, etc. (a total of 6 options). When I did my counts, rows with more than one selection weren't counted. For instance, someone chose 2x/year and 4x/year. However, when I use the formula…
-
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…