I am looking for assistance with flagging an overlap of two date ranges. I've read through other articles and cannot seem to figure it out. I need to flag B date ranges if overlapping with E date ranges.
=IF(OR(COUNTIFS([E-START DATE]:[E-START DATE], @cell <= [B-START DATE]@row, [E-END DATE]:[E-END DATE], @cell >= [B-START DATE]@row) > 0, COUNTIFS([E-START DATE]:[E-START DATE], @cell >= [B-START DATE]@row, [E-START DATE]:[E-START DATE], @cell <= [B-END DATE]@row) > 0), 1, 0)
This checks to see if the B start date is less than a date in the E Start Date Column while also being greater than the E End Date (meaning the Start date falls somewhere in an E Date range).
OR if one of the E ranges falls within the B dates (for example the last row with Jan 1st - Mar 31st). This checks if any of the E Start dates are within the B range.
Let me know if this formula is what you were looking to do!
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Hi - We number tasks in our Smartsheet grid using the format XXX.X. When we sort in descending order, the numbers are not in order. For example 200.0 appears below 001.0. Since it is in descending order 200.0 should appear before 001.0. We also want to start using four digits before the decimal point and want to know if…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.