IF formula Help
I need help with creating an IF statement for this criteria
I need a 1 if the Amendment column is populated and the Effective date is in January, a 0 if false
I am doing this for every month but need help creating this first one. I am creating a report out of this so I can sum them and get a subtotal for how many Amendments were created in January
Answers
-
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
These are my columns
The formula I have right now is: =IF(AND([Amendment/Proposal Emailed]@row<>"'', [Program Effective Date] >1/1/23), 1, 0)
I am trying to make it so when the criteria is true it gives me a 1, if not 0, so later I can sum and see how many amendments were sent. I need the date to be only on January, only in february, etc.
-
Hey @Hannahsamd
I think I understand now. Try this formula:
=IF(AND([Amendment/proposal Emailed]@row <> "", [Program Effective date]@row > DATE(2023, 1, 1)), 1, 0)
It worked for me:
Hopefully that solves it for you.
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
@Itai I don't want it to be because I just want it to be the entire month of January. Like counting all of the amendments that were sent in the month of January. So if the date in that column is in january, there should be a 1 and if not then it should be a 0. It should be a column that analyzes every row. That is what I am struggling with
-
^^ and in 2023
-
@Hannahsamd does this work?
=IF(AND([Amendment/proposal Emailed]@row <> "", MONTH([Program Effective Date]@row) = 1, YEAR([Program Effective Date]@row) = 2023), 1, 0)
-
@Neil Watson I am getting Invalid Data type
-
@Hannahsamd are the effective program date & Amendment/proposal Emailed combs date type? And January column text?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 434 Global Discussions
- 153 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are l…
- I have two columns I am using for this formula: "Date Received" and "Days Duration (Received to Listed)". I want the formula below to look at any items in the Date Received column between 1/1/25 and 1…
- Hello, I am trying to create a report or calendar sheet with these weekly rotating roles: Weekly 1st shift Call Center (Mon-Sun) Weekly 2nd shift Call Center (Mon-Sun) Weekend On-Call 1 (Sat-Sun) Week…