-
Clone Columns including Conditional Formatting
I have a Smartsheet that shows the status of an item by date and I'd like to be able to copy or clone the column with all the conditional formatting. Is there any way to do this?
-
COUNTIF substring or wild cards
I have a column of Part Numbers. Each cell in the column may have a single part number or comma separated part numbers. I want to count the number of occurrences of a particular part number in the column. I searched the help and community pages but wasn't sure what's the latest. Is it possible to use wild cards or any…
-
LOOKUP & MATCH together
Hi everyone, I use a VLOOKUP and MATCH function in Excel to find the intersection of vertical and horizontal values (intersection of a matrix / table). I can't seem to get this working in Smartsheet and need some help. For example if I have Likelyhood = Likely and Impact = Moderate then I want the Criticality to return the…
-
Feature Request: Timeline within Smartsheet
One feature that MS Project had that I've had a hard time working around is a timeline feature that is part of the application. I understand that SS integrates with Office Timeline, but I have to pay for this, manually manipulate this, and I have to recreate a timeline each time deliverables change on my plans. We have a…
-
Webform vs Request Form
I really like the Webform feature. It's made things easier with coordination and data entry. Could I also upvote a feature for Request Form (as an extra step)? It would nice if the submitted Webform goes directly to the sheet administrator first to approve before it goes to a sheet directly. Not because it's been submitted…
-
Shade every other row in Grid View
How do I make my grid view smartsheet to automatically shade every other row a different color background so it's easier to read?
-
Feature Request - History view
Ok, so it's nice to be able to see how things are trending, but given that things keep changing it means you need to have to keep old reports or backups around that you can plug into excel. Wait though, we have the history of each cell available within two clicks. And we have the highlight feature which shows which cells…
-
cc for update request
Hey SS folks, I would like to see the option to have a CC list for an update request. I work with remote teams that have onsite managers, and while I do most of the update requests to the team for corrections or omissions - the manager needs to have visibility of the update request so that they can keep the local team in…
-
Comment title structure
Previously you could separate issues and information by a defined 'Comment Title' and then you can add comments under this section, but now the Title needs to come within the first comment and you then had replies. The problem is I am finding this change has unstructured my notes, as they cannot be clearly defined, making…
-
Master sheets - why sheets and not reports?
New to SS. Setting up many project sheets and then want the high level info pulled together onto a master sheet. Videos I've watched say to create a master sheet and link data in from project sheets. Project management webinar I watched has a company that designs/fabricates/installs 10,000 signs per year (complicated…
