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…
Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data points into a sheet, with the potential for multiple line entries occurring per shift per day worked (see example below). I…
As a sourcing analyst I have to take multiple pricing summaries from our consultants and enter the information into our Smartsheet. Currently that means a lot of copy and pasting and painful data entry. My question: Is there a way I can take the PDF they send me and drop it in Smartsheet and it auto populate my sheet based…
Hi all, I just found out how to put new submissions appear on the top of the sheet, but I have old entries that I want it to be included to the top. I want these changes to apply to the old entries, how can I re-arrange these old entries? Thanks.
When trying to add an entry via this Panel on the Details panel on the right, it give me the error message shown below that. Every time, even in different sessions, refreshed, restarted, etc. Can this be done? If not, is there a workaround for quick entry right into the Calendar?
Hi, I have a team that wants a solution that I can't figure out. Any help would be greatly appreciated (even if its a round about way to a solution). Trade submits inspection via form - generates a document/report, and This triggers a notification to Contractor 1 and Contractor 2, so that they complete their independent…
It looks like you're new here. Sign in to post and engage.