Week of and Date of weeks

Hi There,

I have this formula in Excel, and i tried to import it to SmartSheet but it didn't work! Any idea how i can acheive this in Smartsheet functions?


Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Tarek

    If I'm understanding you correctly, you want to check the Date column and if the date listed is Monday, return "Week of MondayDate", otherwise return a blank cell.

    Try this formula:

    =IF(WEEKDAY([Date Column]@row) = 2, "Week of " + [Date Column]@row, "")


    This is assuming that your Date Column is titled "Date Column". This checks the WEEKDAY in the Date Column to see if the WEEKDAY is 2, or Monday. You can turn this into a Column Formula if you'd like!

    Let me know if I've misunderstood what you're looking to do and I'd be happy to help further.

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!