-
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?
-
Extract Numbers from Text and convert to Text
Hi, I have many rows of texts with each having a number within brackets. I would like to be able to extract the numbers from the texts, convert to number and sum them to get the total. I understand that the VALUE function can be used to convert text to number. However, I'm not sure how to extract the numbers from text. Eg:…
-
Background Colors for Attachments & Discussions
I recently submitted a Feature Request and am curious if anyone else would like it as well. Reason: I am trying to increase feature adoption among my peers. I believe this ability will increase the visibility and awareness of Attachments & Comments. Request: I would like the ability to change the background color of the…
-
Deleting Sheets that I can't see?
I recently became a Smartsheet admin for my company, though someone else is still the official plan administrator (when it comes to billing, etc.). People have been asking me to delete sheets for them, sheets that I cannot see because I don't own them nor am I shared to them. Is there a way to see all sheets in our…
