-
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…
-
count if formulas
I would like to count how many of my orders do not have PO number (i.e Po Number cell is blank) Can you help with the formula to do this Thanks
-
Hide Errors Until Cell is Populated
I'm calculating the variance between dates using the following formula. The problem is that an error is displayed if the Actual Start Date is not populated as show in the screenshot. Formula used in Variance Start Date: =NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1 Is it possible to have the Variance Start…