Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula For Finding Quarter

Options
2»

Comments

  • MandyKelly
    MandyKelly ✭
    Options

    I'm having trouble with this one as well. I noticed this was first requested in 2016, is there any update?

    I have a column "Expected Delivery Date" (column type is Date)... formatted in MM/DD/YYYY. I'd like to return a text value based on that date for "Expected Delivery Quarter" (so that my leadership can sort in Card View). Quarter should show Q#-YYYY or Q#-YY.

    Is this possible? I've tried a million things and have been all over the community to figure it out and I keep getting unparseable errors. Thanks in advance!

    · Share on FacebookShare on Twitter
  • Faith Glass-Wilson
    Faith Glass-Wilson ✭✭✭✭
    Options

    The formula below will give you YYYY – Q#

    =IFERROR(YEAR([Expected Delivery Date]@row) + " - " + "Q" + INT((MONTH([Expected Delivery Date]@row) + 2) / 3), "")

    · Share on FacebookShare on Twitter
  • MandyKelly
    MandyKelly ✭
    Options

    THIS IS AWESOME AND JUST SAVED MY DAY! Thank you :)

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories