-
Sumifs for Multi Select Drop Down
I have a column that is setup as multi select. I would like use sumifs but only sum the 1 item from the multi select. Do I use an OR statement? For example: column 1 is called task type, 1 row has outdoor, indoor, flooring; column 2 is called hours worked and the value is 4. The calculation would only add 4 not 4+4+4=12.…
-
Add x months to a date
Hi All, I have being googling for an hour and haven't figured it out. I want to add a number of months to the date in column [inspection date]. The amount i will specify in column [inspection period]. That is to say that i end up with a date 6 months on from the inspection date. I can then create an automation that will…
-
Autocomplete date range
Hi All, This is likely something quite straight forward that I'm over looking, but hoping someone may be able to advise - Still relativly new to smartsheets. I have a smartsheet, in which each row reports based on week numbers, such as the below formula. =COUNTIFS({Enquiry Tracker (V1) Range 4}, <=DATE(2020, 9, 6),…
-
Decimal Point formula help
Hi All, Please can you help me with this simple formula the formula in 'Net Revenue' =[Sell (LOCAL CURRENCY)]@row - [Cost (LOCAL CURRENCY)]@row 'Rev %' =[Net Revenue (LOCAL CURRENCY)]@row / [Cost (LOCAL CURRENCY)]@row but it does not like the decimal places which we need for accurate numbers Thanks for help in advance
-
Not sure why my referenced cell moves down when I select the next row (see pic)
The first pic aligns the Rate per/hr perfectly (at bottom of sheet) however as seen in the second pic as soon as I select the next row the Rate Per/hr moves down and thus makes the calculation wrong. Not sure what I'm doing wrong? Does the Rate per/hr need to be in a separate sheet? Any help would be greatly appreciated.
-
What is the maximum length of a formula within a cell?
The following is 4824 characters and it seems too long?? =IF([M1]$44 <> "",SUM(SUMIFS([M1]$54:[M1]$134, $[P&L Impacted]$54:$[P&L Impacted]$134, $[P&L Impacted]@row, $[nonEBITDA?]$54:$[nonEBITDA?]$134, false, $[Impact Name]$54:$[Impact Name]$134, "Forecast", $Currency$54:$Currency$134, "USD"), SUMIFS([M1]$54:[M1]$134, $[P&L…
-
Unparseable error
I am getting the 'UNPARSEABLE' error on the following formula, any insight would be appreciated: =IF(MIN([FPFV (Updated)]1:[FPFV (Updated)]107)= [FPFV(Updated)]@row, (MAX([Actual Go Live Date]1:[Actual Go Live Date]107)+7), TODAY())
-
Choice Eliminator Drop Down List
Has anyone come up with a way to create a "choice eliminator" drop down list. Meaning if I have a ten rows, I could have a drop down list featuring 1-10. When "1" was selected for a certain row, that would no longer be available on the drop down list of the other 9 rows. I am trying to create a priority list for my client…
-
How do I calculate the number of answers based on a specific value
I'm trying to calculate the number of answers in one column but only want the ones that match up with a specific description in another column. For example, I want to count all of the males (column one) that answered "Strongly Agree" in column 2. How do I do this? Thank you.
-
=IF statement not recognizing two cells as matched
Using this formula to check if two values in the same row match, and returning "Yes", "No", or "Hold" to display the associated symbols. =IF(ISBLANK([Column A]@row), "Hold", IF([Column A]@row = [Column B]@row, "Yes", "No")) If they match it returns "yes": green checkmark If they both have values but they don't match it…
