-
Date Range Conflict - Vacation Request Sheet
Hello, I've seen quite a few questions for date range overlap, but couldn't find the solution. The closest I found was the one below, but it was referencing another sheet, not the same sheet I believe, and not sure a simple edit to that formula will make it work for me. Form requests will populate new rows of all time off…
-
Saved Filters Issue Date Type Column
I'm running into a very odd issue with consistent filtering on a date column thats being generated from a formula: We have a column labeled "Filter date" that is set to Date (Restrict to dates only not checked) which has the following formula to trim off the date from a 2ndary column that is a drop down: =IF([Date…
-
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…