Expiry Dates - Compliance Check

jgneely72151 ✭✭✭✭✭

Dear SmartSheet Community, I need your help. I need help in writing a formula that will track compliance for different areas based on expiration dates. If dates are active and will not expire in the next 30 days, health should be green. However, if one or more items in the row will expire in 30 days, yellow and anything greater than the 30 days or perhaps, less than today's date, red. I'm want to make sure I'm notifying individuals within the 30 day window giving them time to update items. Pretty sure I will use automatic alerts as well as thinking about adding a flag column that will automatically flag health that is not green to show non-compliance. Below is how my sheet is arranged. Any assistance is greatly appreciated!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!