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. Archived 2015 Posts
Archives for October 2015
Discussion List
Is there anyway to use elapsed time in Lags like durations?
Such as paint cure times etc.
Copying Alerts/Reminders
I use smartsheet to manage my new client implementations. Each new client gets a new smartsheet. The implementations are tough to manage beacuse of all of the different pieces of information and tasks that are needed from different folks, both internal and external, for for each implementation. Smartsheet has been great…
Date formatting
Hi all, I'm trying to change the date formatting but I have no idea how to do so: trying to set date like May 2016 or 01/05/16 or any other formt but only comes up as 05/01/2016. Can you help me?
Users from another account
We have a vendor who is assisting us with a project and he already has smartsheet. Is there a way for him to have access to our sheets as well with his login or is that not allowed where we would have to setup another account with a new email for him? Did a search and couldnt find same question so bare with me if a…
Sorting tasks then go back to original layour
I have several projects i keep on one sheet. I would like to sort them by due date, update items in the most pressing and return to my original nice layout that has all of the projects with headers and then the items to work on under each heading. Whenever I save a change after sorting by due date, I cannot get the…
How to Hide an Obsolete Smartsheet
We've been using Smartsheet for a while now, and we're accumulating a number of completed projects. We'd like to hide the completed projects so as to remove the clutter. If we can't hide a Smartsheet, we would be okay with re-naming it with a prefix that indicated it was compelted or obsolete. If we can't hide it or…
Sort columns by color
Hi, Is there anyway to sort columns by fill color or text color? When we need to draw attention to certain items in Smartsheet In Excel we use color coding to sort. That ensures that the specific criteria requested will be presented on the top...(not all the criteria are the same ex. by date, so conditional formatting…
collaborators and users
I am new to smartsheet. what are the primary differences between collaborators and a users?
Copy a formula accross a column - not loose background color
You have a formula that needs to be populated across all cell in a column. 1) is there a way to do this without using the drag and pull across the column. The problem I am having is that I am also pasting the format (background color) of the copied cell. My only choice is to redo my color format.
Formula - contidional "past due" based on %Complete and Finish date
list of tasks. I want to calculate the past due date for tasks that have not completed. I have variations of =IF(NOT([% Complete]1 = 100), (TODAY()-Finish1), "do nothing") where it is not working it is the do nothing - it is currently calculating values for items that are complete.