-
Hide rows when a task is completed.
Hello! Smart sheet is a good tool for keeping upto date with daily tasks. However as the days go by the rows increase and they are not in the normal view and we have to scroll down to go to the tasks. Is there a way that the rows will automatically hide after a few days of completion or once the task is completed. Thanks…
-
Bank Statement Checklist and weekly notification of missing statements
Good morning, I am trying to build/find a Bank Statement Checklist that will notifiy me of all missing bank statements. For example, as of today, we should theoretically all bank statements from October 2018 and prior. I would like a monthly email sent out notifying me or somebody of all missing bank statements. I am…
-
What happens when you approach Maximum Rows in Smartsheet?
I know there are many advantages to having many small sheets in Smartsheet rather than one large sheet. However, in some cases, it seems easier to manage to track many small, similar projects on the same sheet. Has anyone had experience with sheets that have a number of rows near or over the Smartsheet maximum of 5,000…
-
How to update a cell with a formula?
What would the syntax be in the formula portion of the update be? I'm confused because some of the formulas I work with have the double quote character in it. For example, I have this as apart of my request. "formula":"=IF([Manager]@row = "Tom Hank", "TM", IF([Manager]@row = "John Oliver", "JO", IF([Manager]@row = "Elvis…
-
Last Modify Date based on Comments
I'm looking to see if there is a way to update the "Last Modified Date" system column when someone adds a comment to a row.
-
Clear RYGB balls on completion of a task
Hello, Currently we are using the RYGB balls as a priority indicator. One of the things that happens when you are completed with the task is that you have to clear the ball manually. I would like to automate the task. <Column 1> RYGB <Column 2> is a drop down with the following "Canceled", "Pending" and "Released". I would…
-
Editing a Drop Down List
I am creating a Tasks List and am wanting to use a Drop Down list to indicate the Client the Task refers to. Our Client list is ever-changing. Am I able to add or delete clients from the Drop Down list without affecting the data in the other Client cells? I am hoping to keep the list alphabetical, so additions and…
-
cell data randomly deletes!
when resting my mouse in a cell, the content randomly deletes (with no action on my part). How can this be stopped? screen recording of deleting - notice Column Title Row 2 - disappears NO ACTON on my part.
-
Indent or minimising rows
Hi, I have several standard grid sheets that are populated via webforms, we are based within the UK. The issue I have is that I don't seem able to include "indent" function to the rows (i'd like to indent per month), as the sheets are growing huge as we have a lot of data being submitted from remote and field workers. So…
-
Sorting Numbers with a "-" in it
Hi all, Probably my incompetence here but i have a confusing issue at the minute. I have a long list of job numbers and am trying to sort them in numerical order. There is a criteria that we use to create these that you should probably be aware of: * Primary number is a 5 digit numerical number (i.e.21495) * If there is…
