Can someone help with correct syntax please?
Answers
-
That would have been in my last formula where everything was all rolled into a single formula.
In your most recent formula:
=IF(AND([Last Report Date]@row >= TODAY(-7)), "Yes", IF(AND([Last Report Date]@row >= TODAY(-10)), "No)
You do not need the AND statements and you forgot a quote after the "No".
=IF([Last Report Date]@row >= TODAY(-7), "Yes", IF([Last Report Date]@row >= TODAY(-10), "No")
This formula is saying...
If the last report date is within the past 7 days then output "Yes". If the last report date is within the past 10 days then output "No". Anything that is more than 10 days old will be blank.
-
I am slowly learning how to word the syntax and you're input is very helpful, I am not blowing smoke up......so to speak what you've done and how you've worded it makes sense to me so once again I send you a thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.8K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 510 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
