IF/AND Formula

kwheeler
kwheeler ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to create a formula to track invoices that are completed under 30 days. 

If the number in the "Invoice Duration" is less than 30 I'd like the next column "<30 Days" to populate with "Yes" 

If the number in "Invoice Duration" is more than 30 I'd like it to populate "No"

 

Thank you for all the help!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!