Flag if date range across weekend
Dear Smartsheet, first, great product and I have been able to learn alot on this forum....however
I am a little stuck with a function/formula. I have a list of tests which is dynamic and changes frequently due to predecessors.
I would like to be able to Flag column "Weekend Run" if the test date range occurs over a weekend AND if "Test Type = Endurance".
I have tried some combination of index/collect and countifs/range statements but no luck, I would really appreciate some help
Help Article Resources
Check out the Formula Handbook template!