-
Can I have an auto number created for parent columns only?
Hello, I would like to have an auto-number created in a column called FO Number, however I only want the number created in parent rows, not their children. The number also has to line up with a separate database I use and therefor needs to start at 1886 for the first job in my sheet. eg. VS-CL01GP407-B will have FO number…
-
Copy & Paste multiple cells with formulas
Hi, I'm trying to copy multiple cells from one sheet to another. The original sheet has formulas that tally up data. When I copy these cells, it pastes the results of the formula, but not the actual formula into the cell. Any suggestions on how to get multiple formulas to copy over (rather than copy and paste each…
-
Share Editing of Groups in Group Management
Creating groups in group management is how we are managing access permissions to work apps. We have a couple of people who help maintain the workapps so that we maintain coverage when staff are not available (on leave, in meetings, etc). We need the ability to edit other users groups in group management. Is this possible?…
-
Standardizing Date Formats in Sheets to YY/MM/DD
The Date column's format is not consistent. My default regional setting is Korea, so I think the date should be displayed in the YY/MM/DD format. However, some Date columns appear in the DD/MM/YY format, while others are in YY/MM/DD. It seems that the default is the DD/MM/YY format, and the format of some Date columns…
-
Copy and Paste from Excel into Smartsheet Project
Hi, I have a smartsheet project and am wanting to copy and paste multiple cells from a MS excel document into the 'task name' column. Can this be done ? Thank you Alan
-
Multi-Level Blueprint/Navigation to Upper Level Blueprint
Hello I have a PMO system with three different blueprints. For simplicity we'll call them: Blueprint Level 1 (Top Level) = Client Blueprint 2 (Mid Level)= Program Blueprint 3 (Bottom Level)= Project When I provision a new project I need to be able to navigate upstream to Level 2/Program. Right now the process is to…
-
Tracking
I'm looking to create a smartsheet that can track our heated bags. So What I'm looking to do is have the employee scan the qr code that I will create and it will bring them to a form they will fill out, then that form will generate with all the employees information for me to see in one spot on smartsheet. I do not want…
-
One Conditional Formatting Rule Not Taking Priority
I apply a similar strategy of conditional formatting to a lot of sheets and don't usually have any issues, but on this one sheet, I have a rule that's listed above the others, but it's not taking precedent over the other formatting rules and I'm not understanding why. I have a cascade of blue colors to denote "header"…
-
Color coding in Calendar for multi sheets
I have a calendar view on a dashboard for conferences that currently is a rollup of over 20 sheets (and growing) that roll up into a report which is published and then is a Web Content widget on the dashboard. Works great! I wanted to change the color for some of the conferences on the calendar to differentiate them. I…
-
Grouping causes "name" to not show in export
I have a report that pulls participants under various managers. Each manager has their own report, and the report is sorted/grouped by employee (see image 1 below). The problem I am having is when I export the report in excel or PDF- it doesn't show any names unnder the employee column (see image 2 below). I can't figure…