Issue with highlight yellow color on weekly automation
Hi Team,
We have received ownership of a Smartsheet with automated notifications. The trigger used on the sheet is "When rows are added or changed", with run workflow condition set to "Weekly". I have two questions regarding this.
1. How to check which day of the week, this workflow is triggered. At the moment these notifications are being sent on Friday every week.
2. We observed that the yellow highlight on the updated columns is not being applied correctly. Example on 13th July we updated the Opening date column for which notification has been sent on 15th July. But this column Opening date was not applied with yellow color.
Cn you help us with this issue.
Thanks,
Tanya
Answers
-
Hi @Tanya Pammy
This from @Genevieve P. - Weekly workflows will evaluate changes to the sheet between the first Friday at 12:00 AM and the following Thursday until 11:59 PM. Messages will be delivered between 12:00 AM and 4:00 AM on the second Friday.
Good article here https://help.smartsheet.com/learning-track/smartsheet-intermediate/alerts-reminders
Highlight Cell.
In conditional formatting where highlight rules are developed there is no way to highlight a cell if a date replaces a date. You could create a rule that applies a highlight if the date is in the next X days though, would that work? - See attached snip where I have selected the ship date column from our sheet.
Cheers.
Cheers.
-
@Jason P ,
Thank you for the information. However this answers the question partially.
The issue is not with HighLight changes or Conditional formatting on the sheet, but rather its with automation. In the weekly automation that this set to trigger on "When rows are added or deleted", this date field change was not highlighted on the automation email. When I test this on a copy sheet, it works perfectly fine.
Thanks,
Tanya.
-
Hey @Tanya Pammy
Here maybe? https://community.smartsheet.com/discussion/69337/conditional-formatting-in-alerts otherwise I'm at a loss.
Cheers.
Cheers.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives