Question/Help with IF Statements
Hello,
I'm working on a sheet for new employees and I'm trying to build a simple IF statement that will display whether or not the employee started, based on today's date.
=IF([Start Date]@row = TODAY, "Yes"), IF([Start Date]@row = >TODAY, "No")))
I must be doing something wrong. Do I need rearrange the formula? I'm trying to avoid having to add a new column, instead of just having this IF statement work.
-Andrew
Answers
-
Hi Andrew
The IF Statement uses the following syntax: IF( logical_expression, value_if_true, [ value_if_false ])
So in your case it would be something like this:
=IF([Start Date]@row = TODAY(), "Yes", "No")
You can next more if's if you want in either the true or false paths as well if you want more condtions.
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
-
You have a few syntax errors. Try this:
=IF([Start Date]@row = TODAY(), "Yes", IF([Start Date]@row >= TODAY(), "No"))
-
Hi Paul, this looks like the formula I want to use, but now it's giving me an error message of #INVALIDOPERATION when I put it in the cell. The only data I'm using is the Start Date Column. What am I doing wrong?
Thanks for your response!
-
Are you able to provide a screenshot of the formula actually in the sheet?
-
Double check that your Start Date column is set to an actual date type column.
-
Okay, that was definitely something that I needed to change. Unfortunately it's still not functioning properly. I get a "Yes" answer in the cell, but even when I change the date to 8/1/22 it still says "Yes", when it should be "no"
-
It looks like you have now removed a portion of your formula. The only time you will get a "No" output is when your IF statement is true which will be when the date is equal to today's date.
-
Thanks Paul, that definitely did something. But now a "yes" occurrence enters a blank cell. But conversely a true no works fine. ???
-
Now the only time you should get a "Yes" is if the Start Date is today. Any other time you should get a no. This means even if the Start Date is in the past you will get a no because the start date is not equal to today.
-
Any idea how to fix it? I'd like the formula to show "yes" and "no" responses, according to the start date.
-
To clarify... You want a "Yes" if the [Start Date] is today or in the past, correct?
=IF([Start Date]@row <= TODAY(), "Yes", "No")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!