-
Hidden Rows show in Email notifications
I noticed in a new sheet format we use, which includes hidden columns calculating billing and pay rates, that the "hidden columns" actually show in totality when the user send emails from the sheet or receives their sheet notifications in their email. This is an issue since I do not wish to share that information with our…
-
Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
-
Removing a row from Resource Management when marked Complete?
I have a to-do list that is tied into my resources - but once the task is complete I'd like it removed from the resource view - preferably by checking a box ('Complete'). Is this possible?
-
Simplified Resource Management
Hello! I am attempting to develop a simplified resource management tool that would allow me to see what users are working on what projects/tasks based on the email in the Assign To column. I do not require the time allocation, just name/email and the number of assigned tasks across multiple sheets and workspaces. Some of…
-
Save Issue
im experiencing a problem with saving after i add a row to a sheet. The save function works normally otherwise, but as soon as i add a new row to my very uncomplicated, reasonably sized sheet, the system gives me the error below. However, If i delete the added row, the save functionality works again.
-
Misunderstanding about what is a row (or not)
Hi, Long story short, I've been experimenting with rows and not rows. Here's a behavior I do not understand yet. I have a sheet. I create a duplicate of the sheet using Save As New I deleted all rows by selecting them and using the Delete menu item from the Row Actions menu. The sheet (both original and old) have the…
-
Nest IF limit or error in statement
Hi Folks - I'm trying to write a long formula that evaluates nearly 40 criteria then based on that criteria assigns a score. Is there a limit on the number of IF statements and if so what is it? If there isn't, then what am I doing wrong here? OR is there a better way to do this? The error I get is #INVALID OPERATION (no…
-
Pre-select certain rows for export to PDF
Community: I run a regular export of a Gantt chart to PDF, and select pertinent rows to include in said report. I do this daily, and currently, have to go in and manually Ctrl-Click to select the same rows over and over... I know I can make these rows at a high level, and then collapse the items below, but the way the plan…
-
Enhancement Request: Provide keyboard shortcuts for moving within a hierarchy
I would like the ability to move to top and bottom of a hierarchy. While not mentioned here: https://help.smartsheet.com/articles/522200-keyboard-shortcuts Ctrl + UP, DOWN, LEFT, and RIGHT will move around in the "range" and stop at the last cell with that has data. (Aside: Checkboxes are odd as some unchecked cells are…
-
Sheets with Formulas & Web Forms
Whats the best way to handle a sheet (with formulas) populated by a web form? Right now, each Web Form populates at the end of the sheet, where the formulas stop, how can I eliminate that from happening?
