-
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…
-
Lock Gantt view date on Dashboard from a report
Hello, I am pulling data into a report and displaying on my dashboard. The gantt view always starts on March 15th. Executives viewing the report want to have it start on today's date. The both the source sheet and report's gantt view is checked to start at today's date, but it doesn't translate to the dashboard. I don't…
-
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…
-
Automatically copy data from email into Smartsheet
I am building a Smartsheet that will track work items for a group. One of the ways I need to have work items added to the sheet is via email. I want this to be automatic (fully automated) so that no one has to open the mail account and copy the info into Smartsheet. I looked at Outlook for Smartsheet plug-in, but it does…
-
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!
