Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
Bonjour, J'utilise un sheet avec 180 colonnes. Dans ces colonnes je renseigne manuellement une valeur "Yes", "No" et "N/A". Dans un autre sheet, je souhaite créer un formulaire "intelligent". Lorsque j'indique un critère particulier "ID" par exemple, présent sur les deux sheets, je souhaite que le formulaire m'affiche…
Hi! I am building a program management tool with multiple projects with their own WBS. I want to create a few different PDFs which can be automated send to key leaders in the project weekly to highlight any major changes, and visually display a timeline (since timelines can't be embedded into Smartsheet dashboards … yet!).…
Hi everyone, I’m a Creative Program Manager working closely with designers, the studio team, and cross-functional teams to ensure projects are released on time. Right now, we use Smartsheet in a very basic way—just a grid with dates. I think my current sheet has too much information and I'd love to streamline. I’d love to…
Has anyone used the Smartsheet plugin for Adobe? Then one for adobe cloud needs to be updated for it to work for Illustrator. I see there is a dedicated one for Photoshop and XD. I would love to hear experiences with the plugin for Photoshop or Illustrator.
We know how important your time is, and we’re hoping you can spare just a few minutes to help us out! We’re conducting a survey specifically for marketers and creatives, and your insights would be incredibly valuable. Your feedback will help shape the future of how Smartsheet supports marketing and creative teams like…
Hello, I am working on a sheet where we have several statuses that can go in just about any order. We have a suggested flow, but it's more to help the user read through and make sure they didn't miss anything. I've listed the statuses below for reference. For example, the user could go from 1 to 2 to 3 to 4c to 14 to 16.…
Hi everyone, I need to delete duplicate rows in a sheet. How can I create an automation to delete one of the "n" duplicate rows? How can I create an automation that deletes a row completely under specific conditions? Also, is it possible to highlight duplicate rows with conditional formatting? Thank you!
I am trying to create a simple sheet for creative design requests. -Organized by status (new, in progress, complete) -I want to create a form for the marketing team member to fill out. Once filled, it automates into the appropriate columns (brief, start date, end date, etc. -Then when a request is added, I want to automate…
I am looking for examples and various dashboards to spark creativity on some new dashboards we would like to create. Please screenshot what your dashboard(s) look like and share - blur any private data as needed. Thanks in advance.
I would love to see this data shuttle feature to include the option of saving as a .PDF. I currently have to export individual sheets as .PDF then drag to another sheet to attach the .pdf to a row. Adding a data shuttle feature that would automate the process of attaching a pdf of one sheet to the row of another would be…
We are using form to create performane data per robot per run ( input can be few times a day) I need to start measuring daily avereage for their performance seperately (1 called North 1 called South) but can't figure out formula for it and then I'm assuming creating a chart would be straightforward? but not done it before…
It looks like you're new here. Sign in to post and engage.