-
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?
-
Sumif Unparseable if to many rows
So I have the following Sumif formula working and giving the proper result. =SUMIF([Business Unit]891:[Business Unit]900, [Business Unit]868, [Implemented FY18 (CUR)]891:[Implemented FY18 (CUR)]900) The problem is the range isn't big enough and if I extent the range to beyond 900 rows I get the Unparseable error message. I…
-
Access (visibility and the option to edit) to SOME rows in a sheet
Hi, First, thanks for members of this forum, you’ve been a great help! I have one main sheet where all (different) legal tasks are listed to help the legal team manage the work load. Only the legal team has access to this sheet. One of the departments however, requires visibility of their related tasks, therefore I have…
-
Help needed with an If/And formula referencing another sheet
Thank you for taking a look at this. I have one sheet where I am trying to show the count for a person on another sheet IF another column has a 1 in it. The 1 represents a checkbox in the ajoining column. For some I have tried looking for the specific name (where you see Courtney) and others had the name listed in a column…
-
Today(-xx) function in Cross Reference sheet
I am trying to make a Primary sheet for all of my escalation formulas (since i have 14 single sheets to use the TODAY() function). so... if(TODAY(-7)> {Date Cleaned}, "enter a name", " ") so if today's date is greater than the LAST entry in Date Cleaned, I want a name to populate, otherwise "do nothing". The "Date Cleaned"…
