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.
Column Dependencies/Conditional Formatting
Is there a way to have one column populate data based on information put in a second column? For example, I have 2 columns "% Complete" and "Task Status" I would like that if the % Complete is at o% the Task Status would auto-populate to say "Not Started". And if the % Complete is 100% the Task Status would automatically update to say "Complete". Does anyone know how to do this type of conditional formatting or dependency? Thanks!