Looking to compare two dates to create an Integer value across sheets
Hello,
I am looking to create a tracker that tells me the quantity of samples that arrived in the estimated time against the actual time. My thought process was you have two date columns Date Column A (estimated date) and Date Column B (actual date). I would in my raw data sheet create a link to Column B first than compare that to Column A, if the difference was a positive integer it would count as 1. And the formula would run for all of the product families with sample orders.
The formula I made looked like this
=COUNTIFS({SHEET1 DATE COLUMN B}<{SHEET1 DATE COLUMN A}, 1)
I did not want to have this count in the same sheet as the date data as the sheet is already quite large and I want to reduce redundant information. This data will eventually end up in a graph anyways so its really just a feeder middle sheet that this formula will be used in.
I hope I made my problem easy to understand, if not I am happy to try to clarify more.
Thank you for any help!
Sebastian,
Best Answer
-
It would need to be calculated on the sheet containing the dates. You can then use a second sheet or row report to create a summary of those rows, but the initial calculation would need to happen on the source sheet.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
It would need to be calculated on the sheet containing the dates. You can then use a second sheet or row report to create a summary of those rows, but the initial calculation would need to happen on the source sheet.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you Paul, this worked for me.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!