-
Perform Count on "Year-Mon" extracted from Created Date
I have a working sheet that utilises the Created Date functionality by Smartsheet (DD-MM-YY HH:MM). I am looking to count the number of rows for every Month in a separate sheet to see new rows added over time. to extract the year-month i have created 3 additional columns: Year (=YEAR(Created@row) Month (=MONTH(Created@row)…
-
Formula countif
Hallo Can you check what i need to do to change the formula . Example When i use formul =COUNTIF([Column2]:[Column2]; [Column2]@row) Then when cell in location is emty ( which is always empty ) then it is i always get total numer of cels … Can someone help me to make formul to make sure this doesnt count emty field into…
-
Formule
I have a general list with all data in In that list i have a column Location Those cells are filled in when we scan a location. i want to make a new sheet inside smartsheet where i can see which location are still free. So i uploaded all the location numbers in a column , this column needs to be cross checked with the data…
-
NETWORKDAY Not Working With Columns With Formula
Hello :) I'm calculating the difference between Bethany's Start Date and Bethany's Updated Start Date. The "Bethany's Updated Start Date" column has a formula. When I use NETWORKDAY, it returns an invalid value and I think this is because the "Bethany's Updated Start Date" has a formula in it. I tried wrapping the formula…
-
Colored Dots Formula
I'm trying to use a formula to populate a column with colored dots based off of a date. This is what I'm trying to do Red - Date prior to TODAY Yellow - Date within the next 90 days from TODAY Green - Date greater than 90 days from TODAY Gray - Date is blank I keep getting the unparseable error. This is my formula:…
-
Formula that can capture duplicate in "Multi Contact List" Column, whether the contact name exist al
Hello SS Community, Wondering if possible to find a formula to add in a helper column to capture when a contact name is repeated or duplicate in different rows, whether the contact name alone or if it comes with other names. I need it to know if a contact was assigned more than once within the same moth, meaning, if I have…
-
Countifs, with a cross reference and an or
Hi there, I'm trying to count how many red risks I have in my RAAIDD log that are not closed or complete. I've written the below, but I can't get it to work. Any advice would be gratefully received, please. =COUNTIFS({NAME RAAIDD Range 1}, "Risk", {NAME RAAIDD Range 3}, ">=8", {NAME RAAIDD Status}, OR(@cell = "Open", @cell…
-
Need Formula Help Looking for most recent activity type but reviewing 6 columns
I need a formula for my metrics sheet to pull the most recent account engagement type from a separate sheet, however I have multiple columns to search for the most recent engagement type. The form connected to the sheet allows a rep to select one, two, or three outreach updates so I have three Account Names, three Outreach…
-
Assigning A Person Based on Tier and Zone
Hi, I am creating an Escalation Tracker for one of our teams. Escalations will be entered via a form and the Submitter will choose their name on form. The Submitter will need to select an Escalation Tier (1, 2 or 3) and a zone (Global or Domestic). When a new row is added, they would like certain individuals "assigned" to…
-
If Statement Help
I could really use some help! I am trying to write an if statement. Based on: Due date being < = -68 New entry is "starred" Entry 1 = "yes". I want it to be complete if it meets the conditions listed above and incomplete if it doesn't meet those conditions. This is what I tried: =IF([New Entry]@row = 1, [Entry 1]@row,…
