Less than 30 days formula not working

rphelps
✭✭✭
I used AI generated formula to make the formula above. I asked that if the date in pink is in the next 30 days, to change another column to say "ready to schedule". It worked on the cell with the date in 30 days, but then it also is showing for dates well outside of 30 days. What's not connecting?
thanks!
Answers
-
Never mind! I found another post on the community page and figured it out! thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 441 Global Discussions
- 154 Industry Talk
- 502 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!