-
Flag or Conditional Formatting?
I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that? I thought I had…
-
Support for Formula if ISBLANK
Hi All, I am stuck and need some help. I am unable to figure out how to return a blank if the Due Date is blank or the Status is COmplete. Can anyone help me adjust the formula I am using? =IF(Status@row = "Complete", "", IF([Due Date]@row < TODAY() + 7, "Due in Next Week", IF([Due Date]@row < TODAY() + 15, "Due in Next 15…
-
Automate Risk Flag
Hi All, I am struggling with trying to find and create a formula to automate the Risk Flag. I'd like to use simple logic to provide a flag if any of the ancestor rows have one of the following values The two columns are Status, with dropdowns, and Risk Level with High, Medium, Low Symbols, and I would like to return a red…
-
Formula for Project Health
Hi All, I'm a newer user and trying to create a few formulas to support the Health of Projects Due. First, I'd like to use simple logic to provide row health. If Status: Not Started AND is greater than 14 days out from Due Date = Gray On Track to Deliver AND is 2 days out from Due Date - Green Delayed OR 2 days out from…
-
IF/AND, OR
Hi All, Smartsheet newbie here 👋 trying to figure out what seems to be a basic formula with no luck... I would like my "At Risk" column flag to get checked if the "Due" column date is past today OR if the "At Risk" dropdown is selected on the "Status" column. Here's my started formula that doesn't include the OR:…
-
Fiscal Week / Month / Year
Greetings All! I am stumped trying to get a Grid to formulate for Fiscal Dates. I am trying to report out and showcase on a Dashboard what has been done This Week (Sun - Sat) , Last Week, This Month, and This Quarter. I have tried several IF, DATE, and various other formulas. I have the report aspect fine, as well as the…
-
Help! Not sure what formula to use???
I have one column labeled, "Earn "C" or Better?" which is a checkbox column. If the student earns a C or better, our financial aid department awards them the money in the column labeled, "How much is the student receiving?" I need to summarize my sheet to show the total amount of dollars dispersed to students receiving a C…
-
Column references keep changing
For some reason my {Range} reference keep changing after I set my formula. Formula: =SUMIFS({Civic 2021 Range 6}, {Civic 2021 Range 4}, " RFP Submitted", {Civic 2021 Range 3}, MONTH(@cell) = 1) I select the column below, test the formula everything fine, then I go it messes up another formula, so I go fix the other range…
-
Multiple Selection - Formula
Hi - I have a question re: a Multi-Selection Drop Down. Right now, our one multi-select has 120 options. More often than not, people select less than 5 from the drop down. When they select from the drop-down, I have to parse what they select into codes. E.g. - Selection 1 = Code 3, Selection 2 = Code 10, etc. I'm using the…
-
Is there a way to push a dashboard to people as a pdf?
I created a dashboard that I want to have automatically sent to a group of people as an attached PDF. I can do this with the sheet, but cannot figure out how to do it with the dashboard. I want to set a schedule so this goes out on a specific day of the month.