-
Cell value is cleared easily for a locked column before unlock
Hi, I have a calculated column field and do not want others (including myself) to override the calculation. So, I made the column as lock column. However, I was able to clear the calculation or value in the column without UNLOCKING the column. My expectation is: - others cannot change the cell values in this column; and -…
-
COUNTIF
Hello and good morning Smartsheet community, I know you can use the =COUNTIF in order to count the number of times a (SINGLE) name or word appears in a range of cells. My issue is that I am trying to count how many times the word safety is used in a range of cells where the word safety is used in a sentence and not the…
-
Add up all PAST DUE Items
I would like to add up all the action items on my Action Item log that are Past Due so I can show this on my project dashboard. How do I construct the COUNTIF statement to achieve this? Thank you from the newbie!
-
Formula Help
Hey, nested IF statements are my downfall so I am hoping someone can help me. I have a column entitled "At Risk" and it's formula is this - =IF(AND([End Date]5 < TODAY(), NOT([% Comp]5 = "1")), 1, 0) It puts a flag in if the % Comp column is not marked 100% and the end date is less than today. However, there are some items…
-
Auto populate from one sheet into blank rows on another
Hi All! I searched for this, but couldn't find an answer. Maybe it doesn't exist! I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I was TRYING to get them to fill out all information on one sheet to keep things simple for them. Is there a way for me to…
-
Unexpected behavior. (Found the Issue)
[Update: I've found the solution and posted it in a comment] I am having some issues with a very complicated set of sheets I have created. Please be warned, I am stressing the limits of smartsheets, and it is a rather complicated group of formulas. That said, information is below. Background: I am trying to optimize a set…
-
Counting total specific drop-down option between 2 dates
Hello! The sheet that I am working with is used to track agreements my department works with. Two of the data points (among many) that we capture is the agreement type within a drop-down and the signature date. I would like to capture the total "Amendment"'s from the drop-down list with a signature date that fall in our…
-
Days in progress formula with multiple criteria
Hello, is it possible to run a formula that gets me the following? If the status is “Not started” or “in progress” then count the number of business days between “date presented” and today, and if the status is “complete” then Count the number of business days between “date presented” and “date completed”
-
Get Max value with criteria check
I have Table with values as below and now I would like to get max value. How Could i can achieve the Results Required ?. Col1 Col2 A 2580 A 2380 B 1860 B 420 C 860 D 2760 D 2710 C 2750 Max Value -- A = 2580 B = 1860 C = 2750 D = 2760
-
countif help
Hi all, I'm trying to figure out a way to sum the number of one column if it has the value of another column. The formula I was trying is: =COUNTIF(Scoped:Scoped, Channel22) I want to know how many are scoped in the scoped column if the channel header is in row 22. It's reading invalid. Any other ideas?