Forum Discussion
TonyaJacques
Qrew Member
would this formula apply to a field that uses numbers instead of a date but still a range? For example: if ([days open] <= 0-22 and [HIPO/HVL] = "HVL", "In Progress")
------------------------------
Tonya Jacques
------------------------------
MarkShnier__You
5 months agoQrew Champion
Are you trying to check if the numeric value is between 0 and 22?
If so, then it would be
IF(
[days open] >=0 and [days open] <= 22 and [HIPO/HVL] = "HVL", "In Progress")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- TonyaJacques5 months agoQrew Member
Yes that worked for me! Thank you!
------------------------------
Tonya Jacques
------------------------------- BobThomas15 months agoQrew Cadet
I was on vacation, actually six pet sitting (4 cats & 2 dogs), so I printed this out when I got home. I will look at.
I actually was going to work on this task, and see I posted a year ago. Thanks, may have time tomorrow.
------------------------------
Bob T.
------------------------------