Week of and Date of weeks

Tarek

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?

Genevieve P.

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