-
Will creating a baseline report duplicate resource allocation?
Hello, in Smartsheet's "Project Management Fundamentals" course, specifically in the section on Reporting, there's a great example on how you can compare the original plan (baseline) to actual project dates. The solution illustrated here is to Save As New the original plan (BEFORE you modify any dates), and save it outside…
-
Be great if Smartsheets could be used offline
A number of regions (countries) have very tight internet use. It would be helpful to be able to download local version, work on it while abroad and resync on return.
-
Accidentally unsubscribed from notification in a row, how do I get the notifications turned back on?
I was scrolling through a notification email and accidentally clicked on "unsubscribe from notifications". It did so immediately instead of asking if I was sure I wanted to unsubscribe (like most other programs do). I don't know how to subscribe again, it is on a row that I have a task assigned so I need to be able to see…
-
Unexpected movement of rows
Hello, A sudden shift of rows happened while using smartsheet. The detail is as follows: Three people worked on a same spreadsheet. One was changing the arrangement of rows, such as shifting row 2 below to row 5, while other two were inputing data in some cells. Then, suddenly some data appeared in rows where no one input…
-
Trying to create a report to use on a dashboard.
How do I create an 'At Risk' report, from a sheet, to include on my dashboard?
-
Formula for RYGG symbol based on RYGG symbols in 6 other columns
balls. The 6 other subcategories/column names are: * Financial Status * Quality Status * Staffing Status * Delivery/Operations Status * Customer Satisfaction Status * Subcontractor Management Status The Overall Status is green if all subcategories are green. The Overall Status is yellow if 1-3 subcategories are yellow. The…
-
Copying/Moving attachments to other rows
Good afternoon, I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements. In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the only way I see to do it is to download the attachment and then upload to the new row (it's…
-
Retaining Email Messages as comments
Is there a way to retain email messages as comments, when they are sent directly from a row in Smartsheet? If not, this would be a great addition.
-
Ignore Parent Records formula & Ranked graph
Hello. I am trying to create a graph that shows the top 10 tasks ranked by the variance between Initial Duration and Actual Duration. To make this work, I want to ignore tasks that are parent records. What would this formula look like? I have created a formula to rank the Variance; =RANKEQ(Variance1, Variance:Variance, 1).…
-
Navigate URL Automation
Hi Team, Is it possible to automatically navigate to a URL added in a cell if specific cell value changes to specific value? Please see below to understand the requirement. I have a tracker sheet for each project. Each tracker sheet having multiple task and once all task completed a formula cell shows to project completed…
