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’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Our organization uses a WorkApp to share information with others. We’re on an Enterprise plan and use Control Center to create and publish a blueprint of sheets, reports, forms, and dashboards across more than 100 projects within the WorkApp. Each project has defined users by role. I’m looking for user analytics for…
I'm not kidding when I say I've spent 8+ hours on this. I'm no programmer so ChatGPT has been pretending to fix it for me, unsuccessfully. I have the problem narrowed down to the JSON output. ChatGPT keeps asking me to update my code and the HTTP Request body in various ways without much change. You'd think this would be…
WORKFLOW PURPOSE: first it gathers and populates our entire users list to a sheet. This child workflow is supposed to use /users/{{userId}} to populate the DETAILS of each user onto the matching row that was just populated. But… I can't get Smartsheet Bridge to pass-through the variables I've set to the Child Workflow.…
Hello, I use WorkApps frequently, and I am trying to introduce it for use throughout our entire organization. An item I wish it included/expanded on: Allow importing of users into a role. Importing from an Excel file would be very useful. I have a client who has a large group of users in one location and wants to use…
I can't get my child CHILD WORKFLOW B (See Below) workflow to run. I've been on ChatGPT all day and it keeps making me run in circles. It works GREAT up until Child workflow B. there is nothing in the run log showing why :( WHAT I'M TRYING TO ACCOMPLISH: Should be fairly simple, right? Not for me. :) This Parent workflow…
Does anyone know of a way to automate sending a welcome email to new Smartsheet users in our company. Our company has access to the app but their account isn't "created" until they login the first time (Okta/Active DIrectory Authentication) My idea would be to use the Bridge to: Make API call using GET /users Add Row to…
It looks like you're new here. Sign in to post and engage.