-
Formula for RYG
I'm looking for a formula that would turn the cell within the Status Column R or G based on if specific cells within the row are filled out vs blank. For example, all identified cells are completed so it's green or one cell is missing data so it's Yellow, and none of the identified cells have info so it's Red.
-
I need help with my summary sheet using COUNTIFS
I have a Summary Sheet that is linked to a Dashboard and i keep getting errors with my formulars. I am using the submission date and completion date from a tracking sheet as my reference sheet Any help on the right formulas to use to get the summaries would be appreciated.
-
Collecting earliest date based on certain criteria
Does anyone know the formula to search a column and return the either the earliest or latest date? or latest date.
-
Conditional formatting based off of blank date cell
Hello! I have tried to solve this problem with a lot of experimentation and reading many posts in the Smartsheet Community. Unfortunately, I just can't get it to work. I am trying to change the color of the circle symbol of a status field based off of the value in a date field (Target Date). I want the symbol to turn gray…
-
If Then based on a date and number of days
I have the following formula that works. When I try to add some IF THEN conditions I can't get formula to work. =IFERROR(WORKDAY([Due Date]@row, -2, {Holidays Range 3}), "pending") I am starting with a Due Date I want to calculate a Final File Release Date 2 days prior to Due Date, but if the days until due date column is…
-
Trouble with a COUNTIFS formula
I can't figure out how to make a COUNTIFS formula to work. This works: =COUNTIFS({Target Launch Date}, <=TODAY(30), {Target Launch Date}, >TODAY(0)) This works: =COUNTIFS({Header}, <>1) This doesn't work: =COUNTIFS({Target Launch Date}, <=TODAY(30), {Target Launch Date}, >TODAY(0), {Header} <> 1) ---------- I'm getting an…
-
I think this IF Then formula.....but need help
I want to set up a formula in the Bonus column. Currently there is a drop down selection for "Global Level". The individual can select 1 option out of 7. GL4, GL5, GL6, GL7... Once its selected, I want a formula in the bonus column that is...."If Global Level is GL4, then 2.5%, if GL 5 then 5%, if GL 6, then 7.5%, etc.…
-
Counting Months Formula
Hello! I have a counting question I need some assistance with. I'm trying to count the number of months between two dates (Date Opened and Date Closed). I currently have this formula: =ROUND(((NETDAYS([Date Opened]@row, [Date Closed]@row) / 365) * 12), 0) It works beautifully, but we've updated our process from counting in…
-
IF THEN formula
I'm trying to incorporate a formula in one of my sheets. I'm going to use terms as if I were referring to Excel since I'm still getting familiar with the terms in Smartsheet. For example, if cell A2 contains a date but cell B2 doesn't have a date then I want the value in cell C2 to return "50%". If cell B2 contains a date…
-
Count formula for Date Range
I need a formula to count the number of records where the Created On field is in current week Monday to Sunday and previous week Monday to Sunday. I think this is just doing the last 7 days and dont take into account the day of the week. =COUNTIFS({SubmittedOn}, AND(@cell >= (TODAY() - WEEKDAY(TODAY()) - 6), @cell <…