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.
Date column changing the default behavior of a column
I have a date column called Date of Resolution . I also have a column next to it called Resolved? which is a drop down of either YES or NO.
What I want is the Resolved column to automatically fill in from the behavior of the Date of Resolution column.
If the Date of Resolution cell is filled in, then Resolved changes to YES
If the Date of Resolution cell is empty, then Resolved defaults to NO
How can I do this?
Tags:
Comments
-
=IF([Date of Resolution]1 = "", "NO", "YES")
This formula should work! It says that if the date is blank, then NO is used, but otherwise it will fill in YES. Its a bit simple, so if you need it to do more I can try to do so. Just let me know!
-
Perfect! Thanks
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 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