-
Count Responses for the Same Answer, for Multiple Persons
I created a survey and used the following formula to count repsonses; =COUNTIFS({2020 IS Employee Engagement Survey Range 3}, "Vin Miliano", {2020 IS Employee Engagement Survey Range 1}, "4 - Agree") The formula works fine for Vin, as his number of responses is 2. I also have another user, Tim, and his response is 2. How…
-
Create SUMIFS formula
I need help creating a formula that will show the sum of the Forecast Amount for any Opportunity that has one of these Sales Stages: 1 - Prospect 2 - Assessment 3 - Proposal 4 - Contracts If it's easier to write one that includes "everything except", these would be the ones to exclude: Closed Won Closed Lost All I come up…
-
Start and end date columns advanced by one year
Hi all, I'm trying to flip ALL dates in the start column ahead by 1 year and ALL dates in the finish column ahead by one year. We're utilizing Smartsheet as our critical path platform so this is something we need to do year over year and manually updating ~1000 rows is not realistic. An exact date is not the most important…
-
Dynamic Formula Change to Date Function
Hello, I have a list of "Created Dates" and I'm trying to pull the appropriate "Created Date" into each Week and under its Day of the Week in a more efficient way. So far I have used "=COUNTIF([Created Date]:[Created Date], =DATE(2020, 3, 1))" to find 1 item for the Week of 3/1/2020 on Sunday specifically. As well as using…
-
How do you Sum a Column for multiple same date entries
I have the following sheet (tracker) that I am trying to total or sum if there are multiple entries for one day. Do you have any suggestions on formulas to use? So for the below, I am hoping to get 1 daily total for 7/14/20. I have tried to create a summary sheet and reference the data from this sheet but I cannot get the…
-
Can I Cross Reference a sheet in client account to a sheet in my account?
I'm trying to enter the following formula =SUMIFS({Barcode packing lists Range 1}, {Barcode packing lists Range 2}, [PIckup Date]25, {Barcode packing lists Range 3}, [KIT# / SKU#]25, {Barcode packing lists Range 5}, "Green") where the sheet "Barcode packing lists" is under my Smartsheet Account and the formula is on a…
-
Dropdown values taken form sheet
Hi, I have a 7 sheets where I choose salespersons form restricted dropdown list. Is it possible to have one source of values to dropdown list. So I dont have to add-delete salesperson to every sheet?
-
Countifs if one range OR another meets criteria
Hi, I am trying to create a countifs formula that counts cells if one range meets criterion OR another range meets a different criterion. I have attached a screen shot of an example. In this example, I want to count the projects with a color of "Red," and either a category of "Difficult" OR a status of "complete" I should…
-
Overall Total % completed
Sorry If this is a repeat but the first post seemed to have disappeared. My Goal is to have the Top row #1 Where that checkbox is to say what the total of completed of all the subtaks below. For example the Level 4 is showing 100% completed so the Top row should show 25% completed. But Not sure how to accomplish this? Each…
-
INVALID DATA Type when using countifs formula referencing from another sheet
Hi, I am computing for weekly counts of leads generated for my report and I am using countifs formula and refer to the working sheet where my data is located. I am pretty sure that I am referencing in the correct Date Column and it's data type is also a Date. But the formula is prompting an "Invalid data type error". When…