-
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!
-
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 ?
-
SUMIFs with Children in a specific criteria
Hi SS Community, Hope everyone is staying safe in the current way of living. I'm looking towards you for help with what seems a fairly simple problem. I want to calculate the allocation % of a Project Manager, for projects that are "Current". The Projects are set up as children under the project manager name. Please see…
-
How do you extract numbers out of a cell and create a chart with the data
How do you extract numbers out of a cell that is formatted in a 12-hour clock and paste the numbers into another cell? I need the column "Time Duration" to know the difference between the "Start Time" and "End Time" and then on possible another sheet show a chart of over a period of time. I was even thinking, I could…
-
RYG and Gray!
Hey, I cant figure out how to add to this formula. I have this formula that someone shared from a seminar: =IF(AND([End Date]@row + 1 < TODAY(), [% Complete]5 <> 1), "Red", IF(AND([End Date]@row -2 < TODAY(), [% Complete]@row <> 1), "Yellow", "Green")) . This give me my r,y,g health in the right time frame i want. What I…
-
CountIFs (Time and Blanks)
We use Smartsheet to provide customers with an invoice and allow them to give us a PO. I am wanting to create a formula that will count invoice past 90, 60, 30 days that have a blank in the PO #. I am pretty sure I have FINALLY figured out the date function, but can't figure out how to "marry" it with the blank function. I…
-
Recreating the formula imported from excel
Hi All, I've recently posted with regards to automatic breakdown of hours based on duration and budgeted, however, no luck. I tried re-importing the file from excel with formulas and this is what I'm getting (see pic). Could you help? There is a formula used in the END DATE which is working fine (not sure if necessary to…