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 2017 Posts
Archives for April 2017
Discussion List
Percentage Complete is 100%, want date to auto fill
So I have a column Percentage Complete that calculates when my other columns are ticked off and complete. When it gets to 100% I want the next column Date Set Up Completed to auto fill with today's date. How do I do that?
Reference Sheet name in a Formula within a Sheet
I've seen a similar request for referencing the parent Workspace (though I didn't see an answer) but I am interested in referencing the name of the actual Sheet in a cell within that sheet. I am planning on auto-filling some of the task names within a sheet with a name from the first task row (this would be the overall…
Filters and sharing as an Viewer
We have a new user with with Admin privileges to their workspace. Their workspace has a sheet and a report. Their report includes data from their sheet, which they need to be able to edit from the report, but needs to also include some data, from another sheet in a workspace that we do not wish to share with the user. They…
Estimated vs Actual Time
How does everyone accurately document their Estimated Time vs Actual Time Spent on tasks for a project? Currently, in our planning process we assign a Start Date and an End Date for each task (with allocation %, duration, and predecessors for each task) once the person assigned to the task acknowledges and begins working,…
Formula -
Trying to wrap my ahead around a formula to accomplish determining the top 5 $value projects in a list. I know in excel I could use the LARGE formula to accomplish this...how could I do something similar in Smartsheet? Thanks community!
Formula vs Conditional Formatting
I was hoping conditional formatting could solve this but can we do IF/AND on conditional formatting? If not, what would the formula look like? If the End Date is in the Past AND % Complete is NOT 100% change End Date Font Red. Currently, I have a formula that will flag "At Risk" column if the date is in the past and %…
Exporting/Backing up Smartsheets with Attachments that are Linked to the Rows they were Attached to
Hi, When I do backup of my Smartsheets, all of my files that were attached to any rows are saved to a separate folder. That's fine, but my problem is, I don't know which rows those files were attached to. I need to find a way of linking files to the original rows that the files were attached to. Is there a way to backup my…
Change the number of working day manually
My project team work on Saturday then next week we are off on Saturday. That cycle keeps going like that. How can I describe that and update in calendar in smartsheet? Thank you!
conditional notifications
I would like to know how can I do conditional notifications on my sheet? I would like to create notification when someone change any column other than (Owner / Assigned) will send out notification to that row (owner / assigned) instead of every user.
Formatting of indented rows
Hi, How do I avoid rows indented under a row to NOT have the same formatting? See screenshot:
