-
Columns clogging downstream sheets
Does anyone know of a way to limit columns moving from one sheet to the next sheet when leveraging Move Rows automation? I'm finding downstream sheets are getting clogged with unused columns and numerous blank cells. This creates confusion when training new employees, but also creates additional workload for managers who…
-
Total Time Spent On Various Sites
Hi I have a sheet that tracks time spent on multiple sites, I'm trying to add this to a metric sheet but struggling to get the metric sheet to add the total time spent against each site as a total. Can anyone help with the formula for this? Thanks
-
Hide Unhide Columns
Hi @Genevieve P., @MMcLain, Last time I checked the Community Discussions on the subject of "hide unhide" under the categories of Smartsheet Basics or Product Feedback there were 1,076 posts about the subject going back over more than 5 years. It seems like some product improvements need to be delivered in this area! While…
-
Dynamic View accessibility
My colleague have created a dynamic vie of the Smartsheet and shared it with me and others. To access the Dynamic view, is it necessary to have a license of the Smartsheet? Or only having the access to that sheet will suffice? I'm getting attached error. Need assistance on this.
-
Create a formula to calculate the price of comma delimited items in 1 column.
I have a vendor registration form that connects to Smartsheet from Google Forms using the Smartsheet Add on for Google Forms. When completing the registration form, the vendors can select up to 4 tables to rent and each table may have a different price. The form automatically created and populates my Smartsheet with the…
-
Merged: Allow for column grouping
This discussion has been merged.
-
Multi-worksheet excel linked to template for each worksheet?
Sorry, I'm new to SS but trying to see if we can use a single template to build access to dashboard for each worksheet in excel (about 30 worksheets in single file). Ideally, we want to be able to see each dashboard without opening a different file, either by tabs or scrolling screens. But I can't find anyway to do it some…
-
Sheet Column for Missing Attachment
Hello, I'm pretty new to creating functions for columns and wanted to see if there is a way to have a Missing Attachment column displaying Yes or No depending on the attachments themselves for the row? It seems like the attachment "paperclip" itself can't be leveraged as a filter in the Work Insights graphs. Thanks! Jim
-
Enable Autosave for Published Sheet (edit by anyone)
I have several sheets whose sole purpose in Smartsheet is to live on a dashboard as published web content and provide a dropdown with names. When the name is selected, it brings up a link to a form URL with the name information URL queried into it. After the link is clicked, a new name is picked from the dropdown to…
-
Project Status to Update a Sheet Summary Status - Formula?
Is there a way to have a formula in a row or in the sheet summary that does the following: When a row is added in one sheet and the project status is Completed, then within the project itself in Sheet Summary change the status to Completed as well? I am not sure if it is possible as one status in one sheet would have to…
