-
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.
-
Monthly Report Generation
Hi everyone, I need to create a monthly generated report, is this possible? I have an online form that departments will submit information to. The monthly report that needs to be generated will be the same information. Should I just create multiple filters? must be a better way. Not entirely sure of the architecture for…
-
Cross Sheet Distinct Count Formula
I'm trying to count distinct values in a different sheet using a cross sheet formula. More specifically, I have parent/child rows, and I only want to count the parent rows. The child rows have duplicate values in the column that I'm counting, which makes me think that something like countif(distinct(something...) will…
