Clear cell data based on dropdown selection
HI,
I need to clear a date in a cell when a dropdown list selection is set to completed. This will then in turn remove the notifications from appearing and removed the conditional formatting used a visual tool.
Ive tested an IF statement on the date cell, by adding the IF statement, adding the date and then selecting the dropdown list option.
Is this even possible?
Cameron
Comments
-
You could either add a condition to your rule that adds if the status is... You can then use the options to check mark each different status you want to send the notification on. In this case you would "select all" and then un-select "Complete".
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives