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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!