Date reference in a formula

Looking to create a formula that says if the date at the column called Chart Review Received is within the last 6 months, than display the value 1. If it is not, leave it blank.

This is what i have so far =IF(Chart Review Recieved<180)


  • Hi,

    I needed to identify when items were a week past due for a specific notification. Using NetworkDays, I have this: =IF([Target End Date]@row <> "", IF((NETWORKDAYS([Target End Date]@row, TODAY())) = 6, "Week", ""))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!