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…
Currently Brandfolder is tagging files as duplicates when they are not. They are similar images however they have different file names and yet one set of assets is tagged as duplicate and deleted. How does Brandfolder decide what a duplicate is? Can this be changed or tweaked on a client-side level? I'm not sure how to fix…
Hello, I am creating a tracking system for PO's that need to be entered into a system. The problem is that a PO can be split into multiple truckloads and delivered to the facility on mutliple dates. The facility enters each PO that is needed based on a schedule but if the PO had been received previously, they do not want…
Hi, I have a workspace that is being used for uploading new information by a group of techs. This information is checked and then uploaded a database by another team. Currently, I have the sheet working to check duplicates within one sheet, but once the data is uploaded to the database the line is moved to another…
Tried using the "find duplicates formula" that are posted in the community, everyone seems to be working, for some strange reason mine is not, wonder why…
Hello I'm trying to find a way to identify or highlight duplicate submissions for travel documents. We have various fields that are required for travel submissions, but the ones that area always consistent are the employee ID and departure dates. I've seen some formulas for IF/CountIFs but can't seem to get them to work…
I imported 140 contacts successfully. They are listed in the "My Contacts" view. However, when I try to pick a user in a column, only my own user contact appears under the "My Smartsheet Contacts" filter. If I add another contact manually in that picker it does not appear in the "My Smartsheet Contacts" view. Its as if…
We have a custom built Smartsheet solution. When it was built the person's full name was used in various places in the solution, used in formula's and automations. What we have discovered now that we are using the solution, is when a person goes in and updates their display name in their settings, from Robert to Bob or…
Hello! I've encountered an issue while integrating NetSuite and Smartsheet via API. The script works inconsistently and occasionally creates duplicate rows in the Smartsheet table. Current Script Logic: A record is created in NetSuite, triggering the script. The script collects data about the parent row. A request is sent…
After much research, I am still stumped. I have set up a Smartsheet that will allow users, via a form, request a date and time slot for hoteling (work desk reservation). I have a link in the form to the dashboard so they can look at the calendar to see if there is availability. I am sure some will not look at the calendar…
I've been perusing the forums for how to have a checkbox column check a duplicate of a row and I can't get any of them to work the way I want them to. Criteria for checkbox being checked: Row ID shows up more than once AND Created column is not the most recent Once I get this figured out, I will have an automation where…
Hi Everyone, Hoping I can explain this well so that someone out there can help me with this. I have built a solution that is quite complex and moves projects around to 3 different sheets. The intake sheet generates a project ID and then when the project gets to a certain stage, it copies to my Active project sheet, but…
It looks like you're new here. Sign in to post and engage.