-
Add hyperlink to related sheet from the report
I'm creating a "summary schedule" report from the project schedule and would like to include a hyperlink to the full project schedule within the report for quick access. Any tips to offer on that?
-
Removing Single Cells
Hello, I am looking to remove a single cell from a grid and have the cells underneath move up but I am only given the option to remove rows which disrupts formulas I have in place. Is this feature of removing single cells available?
-
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
