-
Checking Boxes if Date is Current Week
I am trying to develop a formula to check the box if the Date is today or within the last week(6 days). The formula that I have so far is =IFERROR(IF(AND(Date@row >= TODAY() - WEEKDAY(TODAY(), 1), Date@row <= TODAY() + (6 - WEEKDAY(TODAY(), 7))), 1, 0), "") However, the box is not checking.
-
Using formulas with cells linked to other sheets
I am pulling numbers from separate sheets into a common sheet. In this common sheet, I would like to subtract one cell from the other. Is this possible? I keep getting error messages, # INVALID OPERATION and #INVALID VALUE. I have checked that the column type is Text/Number back to the original sheet. Attach is a…
-
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…