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…
I've completed the authentication process, created a trigger and made sure that the trigger has the right source sheet and event type but I am noticing that I can't get any data from the trigger. My goal is to get the row information when new row is added in my sheet so I can copy some of the data over to another sheet.…
so i have two sheets. one sheets is for new hires that we manually enter the username. we have taken over another group which they fill out another set of new hires from another department. i want to copy that new entry not the entire row because i need to map their info which has a different column name then the column…
LOVE this!!! Can we PLEASE have that each time we need to navigate through our browse button??
I have a sheet named "T1 SQDVP", and I want to copy the "Safety Details" data from this sheet into the "Action Log" sheet, creating a new action under the "Follow Up Action" column. Based on the filter when Column "Safety Action / Escalation" is selected as "Action Required at Tier 1" See screenshots. Any suggestions would…
Hi all, I have a sheet which is organising workflows for different departments. Departments are separated into different sheets since they have different tasks and metrics to monitor and some activities are sequential therefore moving once finished with one department by automation. How can I get row info from 1 sheet to…
Sheet 1: team manually enters weekly updates to dates and metrics Sheet 1 Automation: weekly Friday morning trigger to copy all rows (~5-15 rows) from Sheet 1 to Sheet 2 Sheet 2: ledger of all updates made week to week Report: Pulls in Sheet 2 from 12 projects, displays 8 columns, filtered down to just the prior 2 week's…
If Colors in a dropdown column are setup (In Table View), the Copy Row automation should retain those same colors when copied to the new sheet. Just like how cell colors copy over, I'd like those assigned colors to copy as well.
It looks like you're new here. Sign in to post and engage.