-
Calculate % on time deliveries for team
Hi, I was able to use the following formula to count the % of on-time deliveries per team member. =COUNTIFS([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1, Reviewer:Reviewer, "ABC") / COUNTIF(Reviewer:Reviewer, "ABC") We have several team members, so what formula could I use to…
-
Referencing an entire column from another sheet
Hello, I am working on a cross-sheet formula. The ultimate goal is to write something that says this: If room column on [Sheet 2] contains "room name" AND (date on [Sheet 1] falls between Check in Date and Check Out Date on [Sheet 2]) return the value "reserved," if not leave blank. The trouble I am having is referencing…
-
Formula needed for IF function
I need a formula to say if a certain cell's number is less than 1, then another cell equals 135, and if that same cell's range 1-2, then another cell equals 225, and so on. My ranges are: <1 = $135 1-2 = $225 2-9 = $90 10-19 = $72 20-29 = $67.50 30-49 = $64 50-74 = $60 anything greater than 75 = RFQ It seems I can only do…
-
COUNTIF in Sheet Summary counting things that are not there
I am a formula novice and I am trying to count the number of instances certain criteria show up in a column. I noticed that it is counting extra things. For example, I know that it should add up to 6, but it is counting 3 extra things that are not there and the result I am getting is 9. Is this the right formula to use for…
-
Issue with Linking out to other sheets in our workspace
I have had a problem today trying to create a link a cell to another sheet. When we try to create the link there is an error message; I have tried logging in and out again. both sheets are in the same workspace and there are similar links through the sheet more than one user in my business has had this issue with a number…
-
Multiselect to single line item
Good Afternoon, I am looking to separate a client into their individual renewals from a master sheet that has the client renewal dates in a multi-select drop down: Live Clients List: Client Name Renewal Month Project Manager Client 1 January, July, August PM1 Client 2 February PM2 Client 3 March, September PM3 What I would…
-
Summarising Data as a Metric
We run many projects using smartsheet, each project has a seperate sheet and always adding more. We would like a metric on a dashboard to show the number of x tasks due (i.e. shop drawings or site measure) It is easy enough to count this on a single sheet using sheet summaries, but as you can't select metrics from multiple…
-
SUMIF formula for Summary reporting
Hi all, I am trying to create a sheet summary that shows totals for test results ("Failed", "Passed", "Retested", Pending"). I'm using the formula =SUMIF(Results:Results, @cell = "Pass") to pull the sum of tests passed under a "Results" Column, but this returning 0. :( I'm sure I'm missing something simple! Any tips?
-
Combining If/then with date population
I am trying to figure out a way to auto-populate a date, but only IF a specific condition is met. (Screenshot below) I used the formula =WORKDAY([1st Test Date] 1,6) to auto-populate the "Second Test Scheduling Date", but I would like this to only auto-populate if the column "1st Test Results" is "Positive". Any tips? I'm…
-
Drastic Slowdown in performance
Is anyone else getting a drastic slowdown in performance in smartsheet? Several of my employees are having issues opening reports and dashboards, and having the program crash.
