-
Don't miss these table view updates: performance boosts + new features now live!
Hello Community, As the newest view on the block and the modern evolution of grid view, table view continues to undergo a steady drumbeat of enhancements prioritized based on your feedback. You spoke, we listened, and now we’re excited to share a collection of new and improved features that work together to deliver a…
-
Creating a report frm several sheets to assign tasks without adding an assigned column to each sheet
I have a collection of sheets (10-12) that all have projects in various stages that need a status review/update. This is a temporary process and I need to be able to assign each project to an employee, but these sheets don’t have an assignment column already built in them. Is there a way to set up an assignment system…
-
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…
-
making options in dropdown unavailable if selected already
How to make dropdown options become unavailable (in both forms and sheets) once they’ve already been selected. Example: If a patient books an appointment, that time slot is automatically removed or disabled so it can’t be chosen again.
-
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…