Formula Won't Work...What the Heck?

Platform discussions Special workflows & use cases
1

I’ve been working to get this formula to work and I’m at my wits end. I’m trying to see which items have a due date that’s more than 2 weeks away. I know that this part works and returns a number, but when I put that into an IF statement, it breaks!
Part that works: ROUND(DAYS({Due Date}, TODAY()),0)
Part that does not work:
IF(ROUND(DAYS({Due Date}, TODAY()),0)<15,”2 weeks”, “More than 2 weeks”)

2

try it with straight quotes

IF(ROUND(DAYS({Due Date}, TODAY()),0)<15,"2 weeks", "More than 2 weeks")
1 Like
3

STRAIGHT QUOTES! That was it. Until I just Googled, I didn’t know there was a difference between curly quotes and straight quotes.

Thank you Bas!