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…
Hi all, I am clearly missing something… I have a sheet with columns for the Start and Date Ends and then another column to track the Status (In Progress, Enrolled/Upcoming, Completed). The formula is currently: =IF([Start Date]@row > TODAY(), "Enrolled", IF([Start Date]@row < TODAY(), "In Progress", IF([End Date]@row <…
I'm attempting to create a row in my sheet that shows today's date since the dotted line doesn't populate in dashboard view. That way I have a visual indicator of today's date for my key milestone dashboard. When I attempt to use the =TODAY() function in my start column, nothing happens. The column type is a Date/Time…
We have using TODAY() functionality since 2018-2019 with no issues, why is this issue coming up now? We have opened ticket and I have been told to implement a workaround that according to the feedback in this community is not a full proof workaround. Here is the ticket number: 08096290: Schedules only refresh when the…
It looks like you're new here. Sign in to post and engage.