Sign in to join the conversation:
How can I move completed taks to other location in the same sheet ? I have three different lists on one sheet: completed, active, not completed (as outdent and indent positions). How can I move completed tasks to required list ?
Manually, you can drag rows up and down to put them in certain locations. If you're looking to automate it... I would consider creating a report which will allow you to sort based on a field. This will automatically display your fields by whichever column you want. If you want certain ones appearing at the top you could number your status' like 1. Completed, 2. Active, 3. Not completed... or vice versa.
https://help.smartsheet.com/articles/522214-creating-reports
Mike, many thanks. Could you also advise how make tasks crossed when completed ?
You could do this conditional formatting by setting the format to cross out the row when the task is marked as complete.
Choose Conditional Formatting > Set Condition > Status > Dropdown Setting > Ok... Then Choose the formatting for the entire row that you would like. See screenshot.
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
This should be straightforward information but I can't find it anywhere. How do the Automation triggers work for attachments? I assumed: An attachment is Added = New attachment An attachment is Changed = New version of existing attachment. But I just had an 'Added' attachment notification trigger when I uploaded a new…
