Trying to calculate the time between 2 separate date entries based on criteria
I need to calculate the time between the fill entry and the last fermentation log for each specific batch #, and I need it to work for an entire sheet with multiple batch #s. I can get it to work for an individual batch #, but when I try and turn it into a column formula I cannot get it to translate for each separate batch #. I do have a separate sheet filtering out specific fill entries (if that helps), but not filtering data for each individual batch # as that would involve 100s of sheets.
Is there a formula that might work for what I am trying to do?
Thanks
Answers
-
Can you share the formula that you are trying to use?
Column formulas cannot refer to cells or ranges with specific row numbers such as with absolute references, specific cell references, or partial-column ranges.
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!