-
Countif with Dates and Criteria
I am trying to do a count of a symbol (red dot) by each month. I have a column for the month "Date" and four columns (Missing Mentoring Form, Missing Training Course, SharePoint Error, Skillset Does Not Appear on Training Matrix). When there user selects a drop down to red i would like it to be counted. I have that running…
-
Formulas seems not to be calculated
I have a big sheet of ~11000rows by 30 columns (an asset register) I added 2 columns to calculate the duplicates =IF(COUNTIF([L2]$1:[L2]@row, [L2]@row) > 1, 1, 0) and to select the rows to show in a filter =IF(AND([DuplicateL2]@row = 0, NOT([L2]@row = "")), 1, 0) Copying/pasting or Selecting + CTRL+D the formulas has been…
-
How can I pull a report- or write a forumula to show me Rows with a specific status?
I have created a sheet that tracks the training status of 20+ team members on ~200 SOPs. Each SOP has its own row and Team members are the columns. I want to draft a report or pull data into another sheet or easily sort SOPs based on Status for EACH team member. My goal is to be able to facilitate compliance by providing…
-
If formula for RGYB balls
Hi All, I want to create a column so when i change the colour of the ball it changes to a set word. So Green will say "install" for column 7 Red will say "work needed" for column 7 Yellow will say "At VC" for column 7 Blue will say "Back from VC" in column
-
Column Reference Formula Returning Incorrect Answer
I am writing a simple COUNTIFS formula and I am getting a very different answer when I created a column reference vs. referencing a specific range within the column. What am I missing? I am trying to count the number of customers that are not installed or closed to determine how many are "in process". This formula which…
-
Row auto number
Have a column called Row line# and I would like to generate a line number in a column that would represent the line number. so like this: Sample test 1. 2. Each time I add new row under the indented row, smartsheet would continue to count the rows down
-
Copy INDEX formula down for the rest of the column
Hi all, I want to autopopulate the first column of sheet B with the data from the first column in Sheet A I got it to a point with using the INDEX formula to reference, but now I cannot drag the formula down to apply this for the entire column. This is for row 1 "=INDEX({Sheet A MUR TN}, 1, 1)" I think I am missing…
-
Checkbox points total
Hello! I'm trying to create a formula to assign different points to each questions if is checkbox is marked and then have a total score. Right now I have this: =COUNTIF(Done9:Done101, 1) / (COUNTIFS(Done9:Done101, 0, Task9:Task101, NOT(ISBLANK(@cell))) + (COUNTIF(Task9:Done101, 1))) but is 1 point per question and I want…
-
Is there a limit to the number of fields I can use in a trigger for an automation?
I have a sheet that has 50ish columns and I need to copy a row (for archiving purposes) when one out of 25 columns for this row is changed. It seems like there is a limit to 20 triggers per automation - is this correct? Is there a way around this limitation? Yes, I could create one automation with 15 and another one with…
-
Forms
Hello, Suppose I have a sheet that is populated with numerous rows of records that outline key information with a unique code. Each row pertains to an individual and that individual will need to send in information that is in a form. Rather than the form adding a new row, could the form tie together the info in the form…