-
Two new functions released (COUNTM & HAS)
Hi everyone, I noticed that two new functions has been released. COUNTM and HAS Here are the details. COUNTM Counts the number of elements in a multi-contact or multi-select dropdown column cell or cell range. Returns the total number of elements found. https://help.smartsheet.com/function/countm HAS Search for an exact…
-
How to quickly add each week to cells in the same row.
Hi there. I am trying to create a report where the first row has the date of each week in the cells. In Excel, you can type in dates in 2 cells (e.g., 4/2/23 & 4/9/23) and then drag them to the right to auto add the remaining dates. Is there a way to do this in Smartsheet? Thanks!
-
Trying to Output a text value in a column based on values in two other columns.
I am creating a risk register where Impact/Severity is chosen as a dropdown between 5 values (Severe, Major, Moderate, Minor, Not significant) and Probability is chosen between 5 values as well (Almost Certain, Likely, Possible, Unlikely, Rare) where depending on what was chosen in the two columns an output in a third…
-
Riddle me this... CountM on multi-select dropdown but only on parent level row
Hey there Smartsheet community. Long time follower, first time asker. I have a multi-select dropdown with five options and contributors can select all that apply. I need a total that each option is selected, but I only want to run the count at the parent level. For this example, we can say my dropdown column is Strategy,…
-
How do you pull just the Contact Name out of the Contact List?
Hello Team, I have a "contact list" list column which is great because it gives me their email, but is there a way to create a separate column extracting just the "contact name" (no email) from the contact list column? Thanks ahead of time for your help!
-
Exclude negative numbers from AVG Formula
Hi! I need help with a Sheet Summary Formula. We have some negative numbers due to retroactively entering data that we do not want to include in our average. We do not want to include the negative number and we DO NOT want the exclusion to be counted in the average. i.e. there are 10 numbers, 2 of them are negative, only…
-
Using COUNTIF with OR
I'm trying to figure out how to add OR to this statement. Below I'm finding the count of Primary, CAS, Archive, and where Course Development is checked. This works fine. I need to find the same thing now but instead of a singular phase as Archive, I need to find phases such as Concept or Agreement, or Prototype.…
-
How can I calculate the average NETDAYS between 2 columns?
I want to calculate the average NETDAYS between these two columns as a field in my sheet summary. How can I accomplish this?
-
Round average if
@Paul Newcome Good day Paul, Here I bring another question: I am trying to get the Round Average from a master file that contians DC Power and OSP , I believe I'm close to get this but I still get "Unparseable" Trying to count the ones per Month and category already removed Quotes, added quotes, :) =ROUND(AVG(IF({aPP cYCLE…
-
Formula to track issues logged for a specific year ONLY?
Hi! We currently have a log that captures issues for 2022 and 2023. I'm attempting to track our "Ops Issue" and Labeling Issue" categories for 2023 ONLY and am having a hard time with adding additional date criteria to the COUNTIF formula. The screenshot below reflects my latest attempt at capturing the 2023 data. Please…
