Formula Feedback!

Platform discussions Special workflows & use cases
1

IF({Days to Complete Inquiry}> “1”,“:white_check_mark:”,“”, IF({Days to Complete Inquiry}<=“5”,“:white_check_mark:”, “”))

I am trying to use this to checkbox an item when it takes between 2-5 days for a ticket to complete. I have a 1 day ticket formula and a plus 5 day that are both working. This one is check boxing everything OVER 5 as well. Any tips on how I would get this to represent 2, 3, 4, or 5 days? First time on here, but this will be my new home :slight_smile:

2

@SkylarMS

Assuming that {Days to Complete Inquiry} is a number column, the comparison values should not be in quotes. There are some other issues also.

Try this:
IF(AND({Days to Complete Inquiry} > 1, {Days to Complete Inquiry} <= 5), ":white_check_mark:", "")

Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)

3

Thank you @JCorrell, that worked! I have been struggling a few days on that one, so thank you!

4

@SkylarMS

You are welcome. And, welcome to the monday-verse!

Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)