-
Count How Many between Percentages
Hello, I have a list of documents that are being reviewed. People have to indicate what percentage they have completed. So if someone could be 20% done, someone else could be 30%, then another is 50%, etc. I want to be able to count how many are 0% done, 1 - 30%, 31 - 50%, 51 - 75%, 76 - 99%, and 100%. Is there a way to do…
-
Add row data to a separate sheet ONLY if a box is checked
Ok. After 1.5 hours of trying to figure this out myself, I am reaching out to the experts. I have multiple Smartsheet Forms feeding into one Master Data Sheet. Each row of incoming data is then assessed for approval based on certain cell criteria, and if approved I check a box in the "Approval" column (image belwo). Based…
-
Calculate Points of Symbols?
I have three symbol fields Priority (uses Priority High, Low), Impact (uses Measure One, Two, Three, Four, Five), and Size (uses Measure One, Two, Three, Four, Five) I would like to roll up points in a column for this. Impact and Size would convert to integers, High Priority would add +5, Low Priority -2. Can I do this all…
-
Percentage Complete Column (Breaks)
Greetings, I've discovered that the % Complete Column in a few of my sheets has broken, is incomplete at calculating the true completion percentage for a project. I suspect this might have happened somewhere along the line of adding/removing rows. Is there any way to see/edit the formula to ensure it is counting all rows…
-
working with forecasting and actual sales amounts
This is the formula I am trying to activate to pull some sales data from a master sheet to a monthly summary by sales person. =SUMIFS({Current Lead Opportunity Tracker 2019 Range 3}, {Current Lead Opportunity Tracker 2019 Range 1}, "xxxx@xxxl.xx.xx", {Current Lead Opportunity Tracker 2019 Range 8}, "2", {D&C Current Lead…
-
Posting/Including data from another cell.
Within my sheet I have two columns that contain time (hh:mm:ss). In the third cell I am comparing the two columns. If they do not match a statement is posted in a cell stating something is wrong. What I would like to add to the statement is the value from one of the cells containing the time. This works, with no added…
-
Roll Up Harvey Balls
I am currently working on a tracking page where I've been asked to create a "Progress" column using Harvey Balls. The goal is to use empty, half and full to represent not started, in progress and complete by training module (children) and then overall. Below is one of the many formulas I've been working on.…
-
Countifs Formula using a date range given
I have long countifs formulas on a metrics sheet and is pulling all data from an archive sheet. One of the colums on the archive sheet is date. I need to limit the data count on the metric sheet to only count if is it in between (and including) start and end dates given at any time. =COUNTIFS({Score}, "Pass", {Club}, "AAA…
-
Date Formlulas for Dashboard Counter
Hello, Trying to set up formulas from a sheet to post to a dashboard, somehow came up short. I have a number of projects listed in my sheet with a [Go Live] date. I would like to count the following: * Number of projects that are within 30 days of Go Live (but not past go live) * Number of projects that are within 7 days…
-
duration between 5/30/19 and 6/4/19?
Hi all, 2 in May and 2 in June right? 4 total Why does the 2nd row show 3? Darrell
