Skip to main content

If today falls between start and end date, check box help? - SOLVED

  • March 19, 2020
  • 7 replies
  • 66 views
S

Hello,

I am trying to keep track of different screens that are active during a set amount of time. There is a “Start Date” column and an “End Date” column. I need a column that will automatically put a yes or a check when today’s date falls between the Start and End. I’ve tried this but it’s not working:

IF(AND({Start Date} <= TODAY() , {End Date} >= TODAY()) , “ :white_check_mark: ” )

It’s saying that “Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.”

Any ideas on how to get around that?

Thanks!!

7 replies

Kamille_Parks11
Forum|alt.badge.img+27

Your formula structure is fine. Make sure to use straight quotes (" or ') instead of curly quotes (“ or ’) when writing formulas.

S
  • Savannah_Willar
  • Author
  • New Participant
  • March 19, 2020

Your formula structure is fine. Make sure to use straight quotes (" or ') instead of curly quotes (“ or ’) when writing formulas.


I replaced the curly quotes with regular ones and it’s till not working. Something about “result type not a number or a date”

Mohamed_Swella1
Forum|alt.badge.img+17

I replaced the curly quotes with regular ones and it’s till not working. Something about “result type not a number or a date”


Hi @Savannah_Willard,

Its a formatting issue as you said. Check the formatting tab of the Date fields and make sure its set as Date not as Text. If that doesnt help please show me a screenshot.

Justin_Barrett
Forum|alt.badge.img+21

I replaced the curly quotes with regular ones and it’s till not working. Something about “result type not a number or a date”


What’s your desired end result? In your initial post you said you wanted a check mark, and the check emoji does that, so I think we’re confused about what you hope to accomplish by changing the formatting. What format would you like it to be? Only numbers and dates have formatting options. The check emoji is considered to be text, and text output from a formula can’t be formatted.

S
  • Savannah_Willar
  • Author
  • New Participant
  • March 20, 2020

What’s your desired end result? In your initial post you said you wanted a check mark, and the check emoji does that, so I think we’re confused about what you hope to accomplish by changing the formatting. What format would you like it to be? Only numbers and dates have formatting options. The check emoji is considered to be text, and text output from a formula can’t be formatted.


@Justin_Barrett I’m not sure what you mean? Sorry, I’m new to formulas. I’m not trying to change any format, that I am aware of. Why can’t the output be text? All I want it to do is put a little check mark if today’s date falls between the Start and End. The formula does work if I put a number instead of the check mark, but I would like the check mark for organizational purposes. Does that make sense?

Mohamed_Swella1
Forum|alt.badge.img+17

@Justin_Barrett I’m not sure what you mean? Sorry, I’m new to formulas. I’m not trying to change any format, that I am aware of. Why can’t the output be text? All I want it to do is put a little check mark if today’s date falls between the Start and End. The formula does work if I put a number instead of the check mark, but I would like the check mark for organizational purposes. Does that make sense?


In this case, the checkmark has to be between quotation marks.

S
  • Savannah_Willar
  • Author
  • New Participant
  • March 20, 2020

Well not sure what I did differently but I tried the original formula (with regular quotation marks) I posted and it worked :woman_shrugging: Thanks for everyone that gave feedback!

    Terms & ConditionsAccessibility statement