The date format is 30.07.2020 (day.month.year)
Here is what I’m trying to do, but I fail miserably. I’ve tried everything I could find on the subject.
[Start Date] should be newer than today. (Aka, In the future)
[END Date] should be older than today (Aka, In the past)
In generally the formula should be like AND([Start Date]>TODAY(),[End Date]<TODAY()), but I’m assuming that the Start Date is smaller than End Date. If that the case, there is no formula that could give you a result as TRUE.
Yes, that whas the results I got when I tried that. A blank page. They worked seperately when I tried. But not together.
I’m trying to filter out contracts that has not started yet and contracts that has ended, so the user doesn’t see these rows. Any thoughts on a workaround?
EDIT: It was just a simple OR statement that was needed. Hashtag: Know when to take a break…
AND(
[Tjeneste]<>“Matteleie”,
[Tjeneste]<>“Skadedyr-avt.”,
OR(
[Start Date]<TODAY(),
[End Date]>TODAY()
)
)
Excellent!
Just tested some more.
This is a really expensive formula. Look at the values in the middle. Before and after is without this formula.
I don’t get it
Why wouldn’t this work ? :
AND(
[Tjeneste]<>“Matteleie”,
[Tjeneste]<>“Skadedyr-avt.”,
[Start Date]<TODAY(),
[End Date]>TODAY()
)
I think that “OR” will also give you contracts that started and ended in the past
Not sure why. I ended up with using apps script instead, adding “1” to a column if I want that row to hide.
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |