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.
IF function/moving row's across sheets
I have multiple project sheets, whereby each row represents information about a project.
I would like to know if there is a feature whereby if i was to enter into a field that this project was complete, that the entire row could be moved to a new sheet for completed projects.
E.g. if i were to enter a "tick" or the word "Complete" into a column i've created, this entire row then move automatically out of this ongoing project sheet, into a closed project sheet with all other closed projects.