-
Moving only one duplicate using automation
I'm using the following to find duplicates on a sheet: =IF(COUNTIF(Title:Title, Title@row) > 1, 1, 0) That's working fine, but I'd like to use automation to move one of the duplicates to another sheet, leaving only 1 unique value in place. At the moment, all I can do is move both duplicate value to another sheet…
-
Smartsheet University & License Removal
If someone has a license and you remove their license, is their progress in Smartsheet University lost? If you give them back the license a month later, could they log in and continue the Core App path or would they have to start over?
-
Deleted unsused active reference keeps coming back.
I have waited at least a week and it still happening. The references are no longer being used. I have tried browser fixes and other optimization. This is happening on all sheets. I have confirmed that other users are also experiencing this. I will be reaching out to Customer Support but I would would like to know if others…
-
Sharing Across Domains - Only get View Only Access
We create many Smartsheets for clients who have Enterprise licenses (we have a Pro license). When we share a sheet with them, whether it's Editor or Admin level permissions, they only get "View Only" permissions. Is there something we or they need to do to get Editing permission?
-
Dashboard widget titles - can you reference sheet cells or summary field values
Hi all, I am presenting three pie charts whose values come from a meta sheet that provides monthly totals automatically each month. So for example below shows what I have put in place. The dates are pulled as metrics from the meta sheet, but I am unhappy with the whitespace this creates. Being able to reference the value…
-
Allow row in separate sheet to automatically update cell info
Hey there, I have a sheet (Sheet A) where when I add a new row and click a certain checkbox, that row is copied to another sheet (Sheet B). Sometimes, I will need to change the information in the predecessor row from Sheet A, like clicking another checkbox or adding information to a Notes cell. How do I make it so this new…
-
Automation / Form(?) Help
Hi, I have created an event data sheet that has six columns (event name, date, attendee and then three other informational columns). The first three columns (name, date, attendee) will be filled in by my marketing department. I need to create an automation that emails the attendee and asks them to fill out a questionnaire…
-
Template for repeat tasks
We have a one Smartsheet for a list of different type of training events we run throughout the year with associated tasks. We have templates at the very bottom of the smartsheet, to copy and paste, for different type of events and the associated tasks. Is there a way to save these templates and also have certain tasks to…
-
What is the best way to add table like data for user to fill in a form?
I am asking people to complete a form when their salary is split between projects/schools. (1) Name (2) Employee ID: (3) Start Date: (4) End Date: More than 1 project? Y/N *if more than one, I need the following for EACH project and some folks have 5-6 projects (5) Project name, (6) flat amount or (7)% of base salary, (8)…
-
Customer, value contracted, by month for Metrics
Hi, I have a grid that contains multiple columns, that include: Customer Value $ Date Contracted I need a formula that will return all these results that can then be presented via a bar chart that shows the customer and value contracted by month, either stacked (best) or shows if you hover over the bar (acceptable) - but…