-
Automatic Archiving
I'm creating a weekly schedule in a sheet and I would like to automatically archive that sheet after the week is finished, and save it as the name of that week. Does anyone know how this would be done? Thank you!
-
Maintain dependencies on drag and drop in GANTT view
Hello, I have a support request on drag and drop dependencies. * SMARTSHEET changes the date, if I drag the predecessor bar to the successor bar * SMARTSHHET looses connection of dependencies if I move a connected bar left or right This "simple" described problems can be fixed manually by myself but it's annoying,…
-
Auto group like cells
Is there a way to auto group cells that are the same, and add a count of them next to the parent cell? For example, I have a sheet that looks like the first screenshot (ex1), it's a list of SKUs within a program and a project. I want to group all SKUs within the same program/project and count the number of SKUs (see ex2).…
-
Alert when adding a new row
Hi, We have a sheet where we keep track of current statuses of our clients and this act as a mini project management tool for our clients. Each client is in a row and the stages are indented underneath. We would like to create an alert to notify specific persons everytime a new client is added, and this we have done it by…
-
Charting cell values over time
Hello, We are using the smartsheet as an interactive issue resolution tool in a workspace environment where each project has its own smartsheet. We have the dashboard set up which pulls key data points we are aggregating within each smartsheet (ie number of open issues, how many are high priority, medium priority low…
-
Number and Fraction Format
We currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can translate easily between decimal and fractional display with cell formatting. Will there be a…
-
Formula to auto populate a number based off cell input
I'm looking to see if there's a formula or other means to have Smartsheet auto populate a quote number and duplicate that number if the same name is added later on. I am working on building a quotes log where we input a project name in Job Name which then auto fills to the Job Name Master. Next to the Job Name Master…
-
Formula will function in Excel but not SmartSheet
For some reason I am having trouble getting this formula to function in SmartSheet (even though it works in Excel)... I am wanting to populate a "Y" in 'Valid Approval?' column only when one of the following 2 situations occur: 1) 'Primary Approval' says "Approved" AND 'Secondary Approval' says "Approved" 2) 'Primary…
-
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.