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

Options

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?

Comments

This discussion has been closed.