-
Bridge - Copy Specific Cells to Another Sheet
I'm trying to use Bridge to copy only 2 cells over to another Smartsheet. I've been trying to create the workflow in Bridge using the how to guides that Smartsheet has on their site but unfortunately I can't seem to get it to work. Sheet 1 - Has a form that people can enter in when they aren't using their desk in the…
-
Count if Container Code is Unique
Hello, I have a metrics sheet that is referencing another sheet to count how many counts of a specific Hold/MECQI Reason =COUNTIFS({Hold/MECQI Reason}, CONTAINS("incorrect container", @cell), {Hold Issuance Date}, >TODAY(-180), {Hold/MECQI Reason}, NOT(ISBLANK(@cell ))) I only want it to count if the corresponding…
-
Is there a way to link cells between sheets so data can be updated on either sheet?
I manage requests my organization receives with a main sheet and a couple of sub sheets. Specifically, a form is utilized to generate a new request line item on the main sheet. Then if certain criteria are met, the row is copied to a sub sheet. Unfortunately, the information in the copied row does not update if data…
-
Client Workspace Structure
Hello! I'm currently relearning Smartsheet after about an 8-year hiatus so I am seeking some ideas on structuring our setup. We have multiple clients, some with multiple projects. Each project has several components, but each component has the same set of phases. Would it make sense to create a project plan template for…
-
Copy Pivot Table
Please vote this up! FEATURE REQUEST ALERT! 2 things: I would like the ability in the Pivot App, to "COPY" a pivot table so that it doesn't have to be recreated from scratch every time. It's a waste of time and has too much room for human error, especially when trying to organize and create data for hundreds of metrics. It…
-
Automated emails sent by a person who has no access to Smartsheet
This discussion was created from comments split from: Cell History/Email showing the wrong person.
-
Multiple Pivot Tables on A Sheet
In Excel, when you build a Pivot table, you can tell the workbook WHERE you want the pivot to live. If we can add the functionality to Smartsheet so we can have multiple pivots per sheet, that would be extremely helpful, because then I can build my dashboard charts from ONE SHEET vs. from MANY sheets. Happy to discuss…
-
Add Ability to Filter a Pivot Table on Pivot App
The Pivot app functionality is VERY basic. I was surprised to learn that when you are building a pivot table, you can't even add a filter to the pivot. Please include this functionality. The suggestion I was given is to built the pivot off of a filtered report. But then I would need to create so many different reports…
-
NO Project Names on Page
Up until 2 weeks ago, when a project was completed and we received a notification email thru SS with specifics, dates and the NAME OF THE PROJECT in bright blue letters. Now, with no explanation other than it was done as a system ide update and there is no option to go back, the NAME OF THE PROJECT IS NO LONGER ON THE…
-
Sort Formula issues
Hi, This formula causes a #unparseable and can't figure out what is wrong: =IF(Description@row = "Overall Project Risk", "0-00", IF([RAID Type]@row = "", "", IF(Status@row = "Complete", 7, IF([RAID Type]@row = "Decision", 1, IF([RAID Type]@row = "Issue", 2, IF([RAID Type]@row = "Risk", 3, IF([RAID Type]@row = "Action", 4,…
