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.
Highlight work starting on a weekend
![Tom Roy](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I was planning to use
=IF(OR(WEEKDAY([Start]1) = 1, WEEKDAY([Start]1) = 7), "Weekend", "Weekday")
to highlight work starting on a weekend.Where 1 is Sunday and 7 is Saturday. And then use Cond Format as suggested by Greg Gates.
Says "Unparseable"
My Start is Date job starts column and Weekday is column indicating weekday or weekend
Comments
-
The formula looks fine. If there were not date in the date column, you would get an #INVALID DATA TYPE error, not #UNPARSEABLE
If the [Start] column is valid, as soon as you hit 'Enter' in the cell, the [] should go away (they are not needed since the column name has no special characters or does not end in a number.
If they do not, verify your name.
If they do, both instances in the formula should be syntax-colored.
If you retyped the formula into the post here, then recheck it in the original source.
I copied your formula into my sheet and it works fine.
Craig
-
Just did a test and it seems like your formula would work fine if the targeted field is a date field.
=IF(OR(WEEKDAY([Start Date]10) = 1, WEEKDAY([Start Date]10) = 7), "Weekend", "Weekday")
See rows 10 -12 in my Test formulas
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives