-
Help with Countif / Countifs formula
I am trying to count values from a column that is a dropdown/allow multiples column. For example, there are three dropdown options to choose from - red, green, blue. Cells will have one or more dropdown items selected. I need to count all cells that have red selected (regardless of the other choices). THat is, the number…
-
Cross-referencing sheets based on date and month of value
Hello, I'm attempting to create a cross-sheet formula that inserts a date onto a target sheet depending on whether the month and date on the source sheet are between certain date ranges. More specifically, on my target sheet (let's call it sheet B), I have columns titled Spring Meeting, Summer Meeting, and Fall Meeting.…
-
Averaging scores with certain criteria
I would like to get averages of scores of applications sent in considering certain criteria. There are applications that are submitted, and each application is scored by 5 people. You can see these applications are named Q3-03, Q3-04 etc.... Sometimes the scorers recuse themselves from scoring and their score appears as…
-
Sum dropdown list with unique values associated with text?
Hi there, I'm building a QA form where the QA users can select multiple radio buttons in different sections such as below: We'd like each of the radio buttons to carry a specific score, and I'd like the Smartsheet file to then be able to total up the score based on the individual selections. Is there a specific formula I…
-
Count rows in sheet for dashboard metrics
I'm a little stuck! I have a sheet that is for Dashboard Metrics and I want to count all the rows in three different sheets to add to my dashboard. Each sheet contains different contacts so I want to show how many contacts are in the different sheets...what formula can I use on my dashboard metrics sheet to count the…
-
Trying to count total dates in a column for a specific date range
I'm trying to count the number of submissions of a specific activity in a specific time period. For example, I want to count the number of submissions for Task A in (Task A/B column) that were submitted in the period >=3/6/23 to <3/14/23 in (Submission Date Column). I have filtered the file manually and the correct number…
-
Automatically Adding a Cell Value to New Tasks
I need to include the sheet name (project name) in each task I add to my timeline. My task name (first row) is designated with the project/sheet name. I created a column called "project" and I am trying to set it up to have the "project" automatically populate with the project column project/sheet name listed on the first…
-
Using a formula to count numbers of projects assigned to an employee and at what stage its at.
Hello! I've created a sheet to pull metrics from for some charts I need to make and I'm trying to create a formula that counts the number of projects that are assigned to each employee and its progress level. I more or less understand the first part of the formula counting the assigned projects, but I'm stuck on how to get…
-
Project Health Formula
Hi there, My formula seems to be broken. Any ideas? =IF(AND(OR(Status@row = "Not Started", Status@row = "In Progress"), ISBLANK([Projected End Date]@row)), "Yellow", IF(Status@row = "Complete", "Green", IF((TODAY() - [Projected End Date]@row > 0), "Red", ""))) Project Health turns "Green" for any row that has a Status of…
-
Help With Index(Collect with Parent/Child Formatting
I haven't been able to pull this value using the below two formulas.. could someone lend some insight? I have to redact lots of the below unfortunately =INDEX(COLLECT({SSFC DR}, {SSFC C}, HAS(@cell, [Cred Strip]@row), {SSFC Firm}, HAS(@cell, [Firm]@row)), 1)) =INDEX(COLLECT({SSFC DR}, {SSFC C}, CONTAINS([Cred Strip]@row,…