-
SUMIFS in a Dashboard or Report that references another sheet
Hello! I'm looking to utilize a Dashboard or Report and can't, for the life of me, figure out the best way to do this. I need to give a summary of units sold to a customer, per product type, per year. See attached screenshot. Questions or need additional information, just let me know. Thanks, Matt
-
Sumif between dates in different columns
Hi, I have a sheet with the following columns "Resource required", "Shift", "Date From" and a "Date To". What i need to do (Probably on another sheet) is sum the resource column against the criteria in the shift column and for a given date for the whole sheet. Any ideas or help would be greatly appreciated.
-
Is there a way to auto sort data on a sheet (cannot use report) to show the Largest to Smallest?
Hello, I am creating dashboards using metrics and am trying to figure out a way to only show the top 15 of specific data. Sheet details: I have one column that contains 298 different locations and the next column is the # of issues at that location for last week. I have the formulas figured out to pull in the metrics…
-
Avgw based on a criteria
I'd like to apply different weightings based on a staff members role on the staff sheet. I have a weightings sheet that defines the weighting for each task per role. I can't work out how to write an if statement that says, if the staff role (staff sheet) matches the staff role (weightings sheet), then use this row of…
-
Formula TO NOT have to manully enter formula for every row
Good morning, Looking for some help on this issue. We have a sheet with hundreds of rows that tally up to a total (1049.86 hours per below JPEG) We need to calculate the % each piece is from the total . These are the children rows. The first formula I got to work by using =SUM([Total Hours Per Peice]42 / ([Total Hours Per…
-
Automatic Cell data input..Formula???
I am polling permission via web form from 150 of our top accounts. The web form will only collect client info they would know, such as their name, account name, email, contact # and yes or no for permission. However, on our end, when that entry comes in, I need other internal info to auto populate based off the "Account…
-
Extracting Numbers from a Cell Containing Both Text & Numbers
Hi All - I am uploading a .csv file into a Smartsheet sheet. One of the columns within the .csv file is formatted to contain '$ prior to the numbers within the cell (so when opening in Excel, it will not convert the cell contents into scientific notation). I need to remove the '$ text from the cell, so I can sum the value…
-
simple total column
I have set up 2 sheets similar to the inspection submissions and metrics template i found in the solutions center. I use it to collect postage cost per month. I have the submissions feeding into the metrics page with a SUMIFS formula. All of that is working fine. However when I want to total the row for a monthly total…
-
SUMIFS Formula unparsable
Hello, My formula below keeps coming back unparsable and I can't figure out why...The column I need to be summed is referenced first in Range 2. I am also referencing the same date column for that Month and Year criterion. It's on the tip of my tongue but I am running out of options. Any help here would be wonderful. I…
-
Setting flag when task falls within a date range
At my company we have certain dates when we do not make changes to our website (holidays usually). I'd like to be able to highlight or somehow flag a task if it falls within one of the freeze date ranges. Is there a way to do this?
