-
Help with a SUMIF statement but it gives me UNPARSEABLE
I have the following SUMIF statement on the top row of the column - =SUMIF([Plate Size]:[Plate Size], "57""", [# of Plates Made]:[# of Plates Made]) If I change it to the following it works but the problem with this is I have rows that do not have data in them yet and I am not sure if it calculates the newly added data if…
-
Advanced formula/function question.....
I am trying to write a complicated "if" function to search text and provide me with a result if any of the words in quotes are found in the text string. The formula works in excel but I cannot figure out how to replicate it in Smartsheet. Is there someone that can help? This is an example of the formula as it is written in…
-
How to pull latest date from a second sheet for a specific item
I'm trying to pull the latest date a certain site has been visited include that in summary sheet from second containing visits data. In secon sheet, specific can have multiple lines corresponding different vists. Any help with formulas do this would be greatly appreciated. Consider it your COVID-19 effort :). Sheet one…
-
Index/Match with multiple criteria - returning a date
Hi, I am trying to return a date from one sheet to another based on 2 criteria that must match. I have columns COUNTRY, PROJECT TYPE and DATE on both sheets and want to return the Date from the source sheet onto the second sheet based on matching criteria Country and Project type. Is there a way to do that? Been looking…
-
Sum children with one child omitted
I am struggling with a formula that I thought would be easy. I want to sum all children of Total column while omitting one child (Taxes & Freight). The purpose of this is to then multiply it all by Tax and Freight mark-up % (Qty2051) . Obviously I can manually add the various children by referencing the row numbers, but I…
-
No AVERAGEIFS so I tried AVG(COLLECT) but can't get it to work with multiple criteria
Hi, I'm trying to calculate the average of the operational speed [plants/h] only if the [job type] is "Grafting TOM" (cells highlighted in yellow) and also IF [week NO] is a certain value: so basically the average speed for each week for each job type. This formula will be on a different Metrics sheet on the same folder…
-
Adding numbers in a column that are links to other sheets
Good morning/afternoon everyone. I am just stumped. Looked throughout the community and I'm not sure what is wrong. I have several columns on what I'm calling a master tracking sheet that pulls info from 32 other individual sheets. I have used the same formula for each of the columns however the first column "open for…
-
Formula to Find Completed Tasks within One Month or Three Months
First post, pretty new to Smartsheet, need some assistance with a formula. I'm trying to Create a Sheet Summary formula to calculate the amount of Tasks completed within a month and quarter so I can represent that information as a graph in a dashboard. Any help would be much appreciated! Thanks!
-
Cross Sheet Referred Cells - Formula not working
I had received an email saying that the limit to cross-sheet referred cells in a sheet have been increased to 100,000. However, when I use formulas such as COUNTIF, etc with the reference range from another sheet. I still get the following message: How to fix this ?
-
Set a row to 'not applicable'
Hi. My project contains 3 sheets to represent network areas and includes the site locations within the networks. The project tasks are the same and include deployment stage gates and user adoption stage gates. We would like to use the same set of stage gates across all of the network areas for consistency and reporting,…