Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I am trying to make a rule that when I am finished with a cell and change a status on that cell it will then transfer it to another sheet. In short when I am finished with a project and have colleceted payment and finished with the set project; that I can make a rule to where it will then have a pre set rule to where I can just click it and then it will move to my inactive sheet of completed work.
I am not sure I got your question right, so below are several proposals that might inspire you.
. If the purpose is to classify pending/achieved rows, you can create a status column and work out with filters of course.
. If the purpose is to list achievements, keep the status column and make up a report that will specifically pick up rows whose column has the "achieved" sign ✓.
. If the purpose is to get rid of the achieved work and archive. Here is a great blog post from the Smartsheet team on methods to archive sheets: http://www.smartsheet.com/blog/tips-support-don’t-delete-archive-your-sheet#sthash.mOlkhoO6.dpuf
Automation to that sort of level is not available in Smartsheet. It does not have a Macro language a such. To automate that sort of action would require accessing the smartsheet using the API and writting code.
You can use Conditional formatting to highlight rows that need to be archived, however the actual archiving is a manual process.
You could try the app Zapier. That might work for what you want to do.
