-
FIRST OF THE MONTH AFTER 60 DAYS
I am trying to auto populate effective dates for benefits and I cannot get the calculation to work past the first part (60 days after start date) I need to have the following result as an example Start date: 1/15/2020 Effective Date: 4/1/2020 Thanks!
-
Flag overlapping projects based on RYG ball
I've looked and am unsure if smartsheet is even capable of this, but can I turn on a flag based on if a new rows start date falls in between the start date and completion date of any other row? I'm also trying to have it triggered ONLY when the complexity (RYG ball) is red. Am I far off with this formula: =IF(AND([Start…
-
Change RYBG Color if the year is Greater than the current year
Hello, I currently have this: =IF([Wants refresh?]2 = "Yes", "Green", IF([Wants refresh?]2 = "No", "Gray")) Which is working fine, but now I want to add that if the column Refresh Year has the year greater than the current year (2019) for it to turn red. I am not sure how to write that. Any ideas? Thank you!
-
Countif This Month, Next Month, Following Month
Heyo, I am trying to redo a formula to auto update with the information that I am currently pulling monthly for a dashboard. I am trying to sum the total fee installed if scheduled to complete this month, next month, and the following month. Here are the formulas I am using: This Month: =SUMIF({ECD}, IF(ISDATE(@cell),…
-
COUNTIF and Multi-Select
Hello all, Here is a sheet with examples of how to use a COUNTIF formula the release of Multi Select. Hope it helps! Best, Kara
-
Show Last Month of a Quarter
Hello, I have a column that has the quarter, like Q1, Q2, Q3, and Q4. Now I'm trying to show the last month of that quarter on a new column. I tried to use IF([Refresh Eligible Quarter]@row) = Q1, "March") but it doesn't work. Any idea? Thanks!
-
IF Statement to set a symbol to a value - #Incorrect Argument set
Good Day, I am trying to set a Symbol value using this IF statement but I get a "#Incorrect argument Set =IF([Prev Year Difference]3, =0, "Unchanged", IF([Prev Year Difference]3, <0, "Up", "Down")) The column/cell that I am using the formula in is defined as a "Symbol" using the "3 Direction" Up, Down & Unchanged. See…
-
Count dates and return a valve from another sheet
I need to reefer to another sheet and count any row that has a "Fill Superintendent" and return a number if it is =< today in column. Then a valve if its => 60 days Thank you for any help
-
Formula help recognising multiple words
Hi, I have a formula that looks for a specific word or variance of the word, is it possible to look for more than one word? The formula i have is =COUNTIFS(Response1, FIND("shower", LOWER(@cell)) > 0) This works for the word showers or shower which is perfect, however am i am able to count if the cell contains either…
-
How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?
Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the…