-
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
-
Basic Logic for Data Updates
System logic used to 'prompt' users upon data entry to validate that the user is doing something on purpose despite it being illogical. An example would be - entering a date within a date column that is in the past (or future; depending on the actual column).
-
Need update to keep columns collapsed
I've seen many thread with this, none of which have the answer the user was looking for, so I'm starting a new one, hoping this can be an update. I manage a log with many graphic designers who share this log with me. For items not yet on order but have item #'s created, I like to keep them under a parent row neatly tucked…
-
Backspace, enter and delete keys not working...
This has happened a couple of times before. However, when trying to update a form or even a field in the smartsheet, I am unable to use the backspace, enter or delete key. I use Google browser, however I wasn't sure if it was Google, so I switched to Microsoft Edge. Still not working. Also, I tried using the backspace,…
-
Reaching Cross Reference Max error prematurely
I Saved as New an existing Project Metadata sheet with 90+ cross-references. When I removed the old cross-reference formulas. I was only able to add 6 new cross-references before getting the "Unable to create cross-sheet reference, because this sheet already contains the maximum number of different cross-sheet references"…
-
Displaying multiple time periods in Gantt view
Is there a way to display multiple time periods in Gantt view? Example: you have staff members that are your primary people, and they are contracted for 4 months, and then secondary or "fill" staff members that sit in when the primary is away on sabbatical or similar break. Idea here is that the gantt bar on a given row…
-
I occasionally get #ERROR results from formulas that are only fixed by a page refresh
Occasionally I have been getting #ERROR or other error messages as a formula result in cells that previously return a valid result, and nothing related to that cell or the cells that are referenced changed. The only thing that finally fixes this is to do a hard page refresh. The attached images show this, and the only…
-
Does anyone use a Change Management Form in project work and have a dashboard?
Hello. Our PMO is beginning to use smartsheet as our primary tool. We're starting with basics and have created a project plan template that also rolls up into a dashboard. We would also like to track change requests and have an overview for reasons, # of requests, # of date changes made due to requests, etc. Do any of you…
-
Allow Adjusting Baseline for Individual Tasks (Row-Level Baseline Reset)
Idea / Feature Request I’d like the ability to adjust or reset the baseline for a single task (or selected tasks) instead of having the baseline feature work only at the entire-sheet level. Right now, “Set Baseline” and “Reset Baseline” apply to the whole sheet. On certain projects, especially in construction, only certain…
-
Automation to add links in a column in origin sheet from destination sheet.
Hi, I set up an automation to copy a row from someone's intake sheet when they assigned it to my team into my intake sheet. We did this so we didn't miss any of the metadata they are capturing. Can I set up an automation that copies a column that has "DAM Link(s)" from my intake sheet back into the original intake sheet…