Date over 30 days = "text" formula help


I have a column where a date will be entered. Based on that date in another column, I want to state "Pending" if the date is over 30 days past the original entry date.

=IF([DeliveryDate]@row > TODAY(+30), "Pending")

I'm not getting errors with this, however, the text "Pending" is not displaying when the DeliveryDate is over the 30 day mark.

Any direction is appreciated.


Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Nathan Horn

    Hope you are fine, please try the following formula and convert it to a column formula.

    =IF(TODAY(-30) > [Delivery Date]@row, "Pending")

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!