-
Formatting doesn't work for copied cells
Good afternoon. Can anyone help me with the following issue? I have a workplan on a sheet, where I coloured lines, separating sections of the plan, in a grey. Afterwards I copied a formula to all of the cells in a specific column, while the whole column became white (i.e. it changed grey into white in some of the lines).…
-
Automatic 'Text Wrap' Feature in Grid View
Hello and thank you in advance for your time! One of the sheets that I use prequently has text wrapped automatically in the grid view. This has only started the last couple of days so I imagine someone in the building has changed this by mistake. I have been tasked to change it back. However, I do not know what I'm doing…
-
Create a filter using other filters?
Hi, Is there a way to create a filter that is made of already existing filters? Thanks
-
Auto populate from one sheet into blank rows on another
Hi All! I searched for this, but couldn't find an answer. Maybe it doesn't exist! I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I was TRYING to get them to fill out all information on one sheet to keep things simple for them. Is there a way for me to…
-
create graph based on cell history
Hi, I need to create a graph that track history of project evolution / execution. So, I need to have a report that contains the date that %completed was changed and the % that was added so I can create a timeline / evolution graph based on this info. How can I retrieve this info from cell history in an automated manner and…
-
Calendar publishing - Change event description
Hello, when you publish an iCS version of a Smartsheet calendar, it would be great to have the ability to change or hide the default event description : This event was published from the Smartsheet named "XXXX". Click here to edit the Smartsheet item: https://app.smartsheet.com/b/home?lx=XXXXXXX This is indeed misleading…
-
Conditional formating Color scale
Hi, in excel I have color scale option within conditional formating which highlights the top, middle and bottom results (you can choose raws columns of cells). How do I achieve that in smartsheet grid/sheet?)
-
Add Chat Item to Smartsheet
We have used the Outlook add-in to add emails to smart sheets but wondering if there is a way to add a chat within MS Teams to a smartsheet similar to adding an outlook email. Thanks, Merry
-
editing locked rows
Good Morning, I have a smartsheet that has had issues with a merge saving since i had multiple users in it. the sequence of the rows is critical but is also fluid throughout the day. i need to lock down the movement of rows to a single user, but i need to have the other users be able to check the checkboxes in the rows. By…
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…