Can someone help with correct syntax please?

Paul Newcome

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.

Mad

https://community.smartsheet.com/discussion/comment/330822#Comment_330822

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