Why Won't This AI-Generated Formula Work?
I used the AI formula generator tool to create a formula to count the cells in a referenced column in another sheet if the due date is in the next 5 days. This is what was created, but I keep getting the #INCORRECT ARGUMENT SET message. I can't seem to figure out what needs to be adjusted. Anyone have any ideas?
=COUNTIFS({MAR_DSS_CTMS_LG_SEC FA Resource Assignment Range 3}, <= TODAY() + 5, {MAR_DSS_CTMS_LG_SEC FA Resource Assignment Range 3}, >= TODAY())
Answers
-
Hi,
Try switching it around:
=COUNTIFS({MAR_DSS_CTMS_LG_SEC FA Resource Assignment Range 3},>= TODAY(), {MAR_DSS_CTMS_LG_SEC FA Resource Assignment Range 3},<= TODAY() + 5)
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
-
Thanks for the idea Darla! I tried that and it's now giving me the #INVALIDOPERATION error message. Any other suggestions on how to fix this?
-
So Sorry! I was out of the office last week. Are your dates in Date Columns?
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
-
@Darla Brown , yes they are. I think I was able to get this working. Here's what I have as the formula now:
=COUNTIF({Ali Projected Completion Date}, AND(ISDATE(@cell ), @cell <= TODAY() + 5, @cell >= TODAY()))
-
If it's working, don't change a thing! lol Sorry I wasn't able to help earlier.
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
-
not a problem! I'll reach out if it becomes uncooperative.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!