-
Options for Sheet Totals to Drive Dashboard Chart
Greetings, Community! Looking for some guidance relating to sheet totals and how to plot them on a chart. The below screenshot if from a pivot sheet. I mocked up a set of totals rows at the bottom of the sheet. My goal is to SUMIF based on the Category (SM, PF, PL, SysOps) for each time range. I'm looking for a solution…
-
Master and metrix sheets
I have a incident report form for a whole corporation. i was to create sub sheets that will pull the whole row based on site and division in to the sub sheets and have them update as information is added to the master. Have no idea how to start this
-
Embedded IF(AND(OR Function Help
Hello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such that all three columns read either "Complete" or "Not required". I've tried to do this by embedding an "OR"…
-
Count if date range
I am trying to create a formula that will tell me how many tasks that contain Map that are Flagged for CSO responsible that are due in 7 days, 14 days and 30 days from the Current Date or Revised Date (whichever is the great of the two)
-
Counting a Unique identifier in a column
Hello SS Community, I am halfway there but seem to be doing something wrong- I want to count how many times a Person shows up in the list and record the number. I have this formula =IF(COUNTIF([Person Number]:[Person Number], [Person Number]@row) > 1, 1) and it is working perfectly to record when the person number in the…
-
Common List
Smartsheet newbee here...so bear with me... I'm tying to create a common list of systems of which there a multiple scopes of work associated with a each system but not really related ot each other....therefore, I would like one sheet which simply lists all the systems, along with basic information....then another sheet…
-
Score Formula
Hi, I am looking for a formula that can look at (High, Medium, Low) and reference a Key Table to decide if something's overall score is (High, Medium, Low). I need something like this: =IFERROR(VLOOKUP(C5&D5,Configurations!$C$14:$D$22, 2,0), "") Key:
-
Index Formula?
I am trying to make an employee sign in sheet that can automatically be updated each day. The supervisor's name is a drop box and they can single select the foreman. I want the "Name" column to update automatically the names that are associated with each foreman from the second screenshot. The sign in sheet would look like…
-
Formula looking at column information
I have a vlookup formula pulling in information from another sheet into a Pivot Table. In the Utilization column I need the breakdown from the columns to the right that match the categories in the Nominated to: column. Which if it's one category I have a formula that's working, =[Nominated to:]@row + " - " + [Sports Med -…
-
Metrics sheet - smartsheet limitations and quirks
This is a bit of an open question and I will try to make sense; I was making a metric sheet, made a set of metrics using a formula (iferror, avg, collect in one formula etc). Then I wanted to do another, with a similar formula, based on a different criteria range. So i copied the formula somewhere else in the sheet with…