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
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!