-
Working Days Counter Based on State, Lock # when completed
I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and still…
-
SUMIF Contact? Help please!
I'm trying to get the total of a column where the row contains a specific sales person. Can someone help me out? Here is what I tried: =SUMIF([Sales Person]:[Sales Person], "Kevin", [Appx. Value]:Appx. Value]) Screenshot attached...thanks in advance!
-
Calculating Number of Items in a Month based on System Generated date field
Hello all - Needing help with a formula to calculate how many requests are submitted via a webform for each month. 2 questions related to this: 1. Can a formula pull just the month from a System Generated cell: Created by (Date)? 2. Where are errors in this formula: =COUNTIF({Date Submitted}, MONTH(@cell) = 1) 'Date…
-
To stop the Counting Counter after One Column Value is changed.
I Have a project in which i have to Calculate the days. From the date form is submitted to the time it is approved by the internal team. I want to stop the calculating counter after the Status of the internal approval is changing. The Approved Column has different drop down list which changes and and thus the count has to…
-
IF THEN statement in a symbol column
Fairly new to smartsheet, so not sure if I'm doing something wrong. I have a priority column in my To Do sheet which is a symbol column (High, Medium, Low). I would like to create an IF statement that will automatically change the priority to "Low" once the task is completed (doing this for the purposes of a report I am…
-
CountIFs EOM Formula
Is there and EOM formula that will use the Month Column instead of manually using the DATE (2019,1,31) format? Excel example: =COUNTIFS(Type of Lead,"Servicing",Date Received,">="&B5,Date Received,"<="&EOMONTH(B5,0)) Smartsheet: =COUNTIFS({Type of Lead},"Servicing", {Date},>=DATE(Month1),{Date},<=EOM(Month1)) Any help…
-
Including FIND in COUNTIF
I would like to use COUNTIFS when two conditions are true * The value in College = "ED" * The text [Development Category] contains the word "Build". EXAMPLES THAT COUNT: College = "ED", [Development Category] = "Build OL only" College = "ED", [Development Category] = "Build BL only" EXAMPLES NOT TO COUNT: College = "ED",…
-
Automate RYGGrey
I need help with a formula to automate my RYGGrey. Here are the rules: If status = complete, grey If status is in progress or not started and finish is in the past, red If status is in progress or not started and finish is today + 5 days (within the next 5 days), yellow If status is in progress or not started and finish is…
-
Formula to add two columns together that meet the same criteria
Hello, Need some help with a formula, I am trying to add two columns that meet the same criteria from one sheet to total on another sheet. I have tried Sumif and sumifs formulas but they both comeback with errors Here is what I need: On sheet 1 I want to total columnA and columnB on sheet two if they meet (this) criteria.…
-
Duplicates, can I count the Original but ignore 2nd, 3rd etc
Hi I had a look but couldn't find the answer. I am trying to do simple reports and formula Counts, but trying to ignore any duplicates. Example below, I am only interested in counting the first time a name appears, so the count would equal 5 Names, ignoring where there is a second or third. Names Andrew Dave Phil Sarah…
