Formula for meeting a certain date


How can I create a Smartsheet formula that checks if it is exactly 10 days before a date in a specific column (term date) and displays 'Ready for HRC' when that condition is met? thanks

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!