-
Baseline and multiple columns
Hello everyone (I hope you can help as I have been searching for an answer all day among the community and other sites but noone seems to have had this problem before.) I have baselined one of my projects and I get additional columns: Baseline Start 2, Finish 2 and Variance 2 (see screenshoot). I have tried: . resetting…
-
Return a value based on the 2nd most recent update for a specific Project ID
I am trying to return a status based on the 2nd most recent update for a specific Project. This is the formula I currently have: =JOIN(COLLECT{Status}, {Row ID}, [Row ID]@row, {Modified Date}, LARGE({Modified Date},2))) This formula, of course, is pulling the 2nd to most recent modified date for the entire list, regardless…
-
Combining these three formulas
Can someone help me combine these three formulas to result in one final Answer? =IF(AND([HP Advance Pull Print?]@row = "Yes", [Account Size]@row = "Small"), 56, 0) =IF(AND([HP Advance Pull Print?]@row = "Yes", [Account Size]@row = "Medium"), 112, 0) =IF(AND([HP Advance Pull Print?]@row = "Yes", [Account Size]@row =…
-
#INCORRECT ARGUMENT SET
I've been using this formula for a couple of years on several sheets. =IF([Current Month]@row = "1", January@row, IF([Current Month]@row = "2", February@row, IF([Current Month]@row = "3", March@row, IF([Current Month]@row = "4", April@row, IF([Current Month]@row = "5", May@row, IF([Current Month]@row = "6", June@row,…
-
Conditional formatting
Hi Team, When I run some formulae and they end up being invalid or such, I need to create a conditional format to highlight the cell in Red. The condition is not reading "#" because its a formuale in there that doesnt populate the value How do I do that
-
Formula Challenge Sheet
Hello! I remember I used to own a sheet called Smartsheet Formula Challenge (there are race cars visual in the sheet) that has few good scenarios/challenges on Formulas which I have been using as a reference! However, since I moved job, I dont have a copy of that anymore neither I know where to find them! Does anyone has…
-
Formula for pervious month
Hello, I need to construct a formula that will show the values of the last month in the history column. Currently, the formula for OUT status is showing values for the current month : =SUMIFS([Amount after Change]:[Amount after Change], Status:Status, "OUT - to the next month", Archive:Archive, 0, [Original ETA]:[Original…
-
Cross Sheet Formula with One Criteria
Hello, I am creating Smartsheets for quality assurance testing. Sheet #1 will be the test scenarios and steps taken. The row will include a drop down menu to indicate if the step passed, failed, etc. I need a formula that if "Fail" is selected from the drop down menu, the step's ID # will automatically pull into Sheet #2…
-
Unexplained #REF error
Hey all! I have a few Schedules that are giving me a #REF error in the Predecessor column all of a sudden. The thing that is odd is that when I dig into the cell references, it says there aren't any. Has anyone seen this before or know how I can clear these errors? Thanks!
-
Generating text in a cell based on a date in another cell, with conditions
Hello! I'm new to smartsheets and I'm sure I've just made some kind of simple error or overlooked something. I am trying to create a formula that will generate text in a cell [Recurrence], "1 week", "2 weeks", or "4 weeks" based on how far out today is from a contract start date [Start Date] - either less than 6 months,…