-
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…
-
Enhancement Request: Allow filter on "special" columns
Initially, I'd like to be able to filter a sheet on: Attachment (yes/no) Discussions (yes/no) Info (each of the possibilities) After that, I'd like to be able to further refine the Discussions (date, author, content) With these in place, I'd like the same functionality with Reports (show all rows with attachments, for…
-
Conditional Formatting: "Today is in-between Start Date and End Date"?
Hi all, I built a filter to show my tasks that are due today with a green highlight. However, it does not capture tasks that last across several days (see the different shades of green in the attached image - bright green is a "today" task, and the woodland green is default). How can I extend my conditional formatting to…
-
Attachments - host on one row link to other rows?
Hi peeps, Wondering if there is a way to host an attachment on one row (standard practice) but allow other rows to 'link' to the same attachment, RATHER than having the same attachment on each row. Example: Shipping documentation is captured for 'on the go' viewing, many times we have multiple orders or shipments bundled…
-
ENHANCEMENT REQUEST: FROM YOUR CUSTOMER BASE
Open Topics Pending Product Reply on: * Fix the link to sheet bug not showing as a URL/link * Unable to unlink, delete and retype in text to fix * Ability to chance the background color in a Sight other what white/grey - fix to allow users to select a color or image upload * Ability to make widgets transparent and just…
