-
Formula that needs to reference multiple columns
Good evening, We are looking of how we would structure a formula to calculate the % of our production job each series is responsible for. * There are 6 series (sequences) in this job. 1 thru 6. In the "Series ID" column. There are 300 rows +/- that make up the 6 series * The 6 series make up 100% of the job as calculated…
-
I can't figure out how to use the OR function in a Countifs formula
Hello, I have been creating metrics on my data in smartsheet using the different formulas. I have figured many out (with a lot of head banging and sleepless nights), but cannot figure out how to use the OR function. works: =COUNTIFS({Week}, =$[Date Range]$3, {Month}, $[Date Range]$5, {Year}, $[Date Range]$8, {task status},…
-
Convert Tex to date with Data uploader
Good Afternoon, We are currently using Data Uploader to automatically move date into Smartsheet. In a few of our sheets the Date is the only unique identifier. However, I have found that using a date column to import does not work as it doubles the entries. If I upload the dates as plain text I have no issues. I have…
-
Dashboard and Sheets - Making 0 appear instead of error or formula
Good evening When we are setting up dashbaords and we have not yet enetered data , how do we make that data show a "0" instead of "# Divide By Zero" , it just looks messy.... Thank you
-
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…
