-
Why is INDEX slow?
Hi, We have been using SmartSheet for many years and have developed our entire project management around it. Every production sheet is derived from the same template. Thus, every production sheet has the same columns and many of those columns have formulas. These sheets now use summary fields, some of which derive their…
-
Highest value on the last six values of data
I'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6,0,6,1)) but I see "offset" is not compatible with smartsheet. I don't believe Index and Match would work with what I'm…
-
Combining IF(AND statements with Dates
Hi - I am trying to build a combined IF statement that takes a last contacted date and a last participated date and if both are true will output a status of "available". If not, it will be "not available". Separately, I can get the a formulas to work for each date, but once I combine the formulas, it fails. First date…
-
How do I set a formula for an entire single select drop down column?
I am pretty new to using SmartSheets and I've just figured out how to use formulas! I've been searching everywhere but I can't seem to figure out how to set a formula for an entire column. I want the formula to be automatically be applied when a new row is added (these rows are brought in via responses to a form). This…
-
using SUMIF / SUMIFS
im now starting to become formula blind, help i have 1 column with a reference to use as the identifier, "1-3" in the image, but i want to SUM up all the values in multiple columns! But the only way i can get this to work is looking at a single column for the argument rather than using the left column to then SUM up all…
-
Formula: Start date + 1/2... days
Hello community, I am trying to add a formula for the following: The date in red is the start date (DATE1). The dates below should be programmed like DATE1 + 1day, DATE1 +2days etc. I tried different formulas I found in the Learning Center but for some reason it didn't work... Thank you for your help! Elizabeth
-
Dividing a value under "1" i.e. 0.71 isn't working
OK, so I have a sheet that's giving me some details on contract spend. One column is telling me the remaining value in a contract, another column is telling me how may weeks are left until the contract expires - i then have a 3rd column that is calculating how much weekly spend is available before the contract expires.…
-
How can I add character count, like in the content calendar template?
I'm trying to add the function of character count in my template. It's the same feature that's used in the Content Calendar feature. What is the formula?
-
status averages
is there a way to get an average how long a cell is in a certain status? currently have status cells are in text. so i would assume i would have to assign a value to them but after that im not sure which formulas to use.
-
COUNTIF Function
Hello, I have a column (column 1) that is limited to a multi-select drop down menu with 5 options call them red, blue, green, yellow, and orange. Every row in column 1 has multiple color selections. How would I write a COUNTIF formula to count every instance of red? I have tried =COUNTIF(column 1, <"red") but do not know…