-
Help setting up formula IF
Hi there, I'm trying to set up an IF formula to pull the Month from the "due date" row. I've been using the following formula: IF(MONTH(DATE@row) = 1, "January", IF(MONTH(DATE@row) = 2, "February"....) Although we have a cut off date which is the 25th of every month. All projects due after this date should be pushed to the…
-
Change symbol based on date
Good morning Everyone, I have been having some issues configuring a formula in smartsheets. Currently the only two columns that matter are named "Status" and "Last Run". What I'm trying to write is a function in which... Green appears if the last run date is within 30 days Yellow appears if last run is within 31-60 days…
-
Formula that will allow a date in text format to be captured in a date format
I have a Date getting imported as 08JUN2021 (2charDay+3charMonth+4charYear) and I need to switch it to a Date format that will allow integration in other formulas and logic flows. So far I have tried these 2 formulas without success: =DATE(VALUE(RIGHT([WES Evaluable Report Date]@row, 4)), VALUE(VLOOKUP(MID([WES Evaluable…
-
Auto checkbox problem
Hi, I am using these two formulas to auto check a box. =IF([Column Title1]@row = "Word", 1) =IF(ISDATE([Column Title2]@row),1) Both work individually, but i am having trouble nesting them and making them work together. I need the check box column formula to check for a word (single select dropdown) in one column and a date…
-
Date Formula
I have two quick questions; I need a formular to express the following: End date of column A = Start date for column B ( I tried setting the columns equal to each other but get an error) Second formula Column C = Column B +10 ( I tried Date1 +10 but get an error)
-
#invalid value error on a counting from previous year month
Hi good day everyone. I have a formula that was working fine until now January. The formula what is doing is counting all new items added in a sheet on previous month =COUNTIFS({What is it?}, "Risk", {Created date}, AND(IFERROR(MONTH(@cell), 0) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY(), 1) - 1), IFERROR(YEAR(@cell), 0 =…
-
I am looking to create a multi-function formula- Count when the course is X or X AND status complete
I am summerizing data for a dashboard in a secondary sheet and need to find if two courses of many are selected AND the status is complete. I have the column before with the counting of the two courses and need to add on the completion status either by referencing the previous column or in a formula by itself and even…
-
Search a specific value within a range
Hi, in this example, I would like to search a value (each cell in Column 5), within a range in Column4. I tried using formula HAS and CONTAINS, but it seems the criteria or search value is not recognized when I click on a cell in Column 5. Appreciate if you can help me to find a way to pull this off. Best regards,
-
If with And Formula help
Hello, I'm trying to write an If with And formula to flag if my micro/QC column contains a specific phrase, and my Date Submitted column is past its date by 12 days. Here's what I have =IF(AND([Date Submitted]@row - TODAY() >= 12, [Micro/QC?]@row = "QC", 1, 0)) I'm getting incorrect argument set error and can't figure out…
-
Countifs with reference to another sheet
Hello, I am trying to use the following formula: =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,"]) and =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,") but it keeps coming up as "UNPARESEABLE."…