-
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?
-
Auto Archive Completed Tasks To Another Smartsheet
Have a smartsheet with about 6,000 rows of tasks with 38 users updating. Since Smartsheet becomes very slow with that number of rows. As tasks are completed we use the move row feature to archive. However we would like to automate this so that when a task is completed it auto archives to another sheet. We have read that…
-
Summary Reporting from a Single Smartsheet
I have a single sheet used to log test defects. From this sheet I've created a summary section at the top for Open Items and Items by Status. I need to create another summary "Item Status by Sprint versus Production". I've tried Reports but this does not allow adding a summarization of the data (equivalent to an Excel…
-
Card View Lanes / Drop down
I'm using a sheet populated by a web form and using Card View as "Default" View. Card View is Viewed By "Machine Submitted By" The "Machine Submitted By" is a drop down selection on the Web form Is it possible to have "COMPLETED" as a lane on Card View WITHOUT allowing it to be a selection on the web form dropdown?
