Formula for meeting a certain date

mahmadi ✭✭

09/06/23 in Formulas and Functions

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

0 · Share on FacebookShare on Twitter

Best Answers

• 

  Shanky Paul ✭✭✭✭✭

  09/06/23 Answer ✓

  Hi,

  Try the below formula:

  =IF([term date]@row = TODAY() - 10, "Ready for HRC", "")

  Thank you!

  1 · Share on FacebookShare on Twitter
• 

  Darla Brown Overachievers

  09/06/23 Answer ✓

  This formula works

  =IF([term date]@row = TODAY(10), "Ready for HRC", "")

  Darla Brown

  What you meditate on, you empower!

  Overachiever - Core Product Certified - Mobilizer - EAP

  1 · Share on FacebookShare on Twitter

Answers

• 

  Shanky Paul ✭✭✭✭✭

  09/06/23 Answer ✓

  Hi,

  Try the below formula:

  =IF([term date]@row = TODAY() - 10, "Ready for HRC", "")

  Thank you!

  1 · Share on FacebookShare on Twitter
• 

  Darla Brown Overachievers

  09/06/23 Answer ✓

  This formula works

  =IF([term date]@row = TODAY(10), "Ready for HRC", "")

  Darla Brown

  What you meditate on, you empower!

  Overachiever - Core Product Certified - Mobilizer - EAP

  1 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list