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 had data deleted from a column in a tracking sheet. (2K+ rows) I pulled a snapshot from the activity log and I want to pull back the data from just the one column. I was told the right process was under File>Import>Update Rows, but I don't have that option under import. Is there another way to do this?
NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr. ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as…
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…
I have a question about Smartsheet. I have columns in my sheet for Monday, Tuesday, etc. Somehow, Monday moved to the end of the sheet. So, now Monday is after Sunday. I looked at the activity log, and it shows that the columns were reordered. How can I get them back to the beginning of the sheet, other than by dragging…
I am trying to auto-populate some dates in my "Due Date" column. When a date is entered in row 5, I need row 6 to be "date" - 5 days. The formula I tried was: =[Due Date]5 - 5 But when I click enter, it just adds a " ' " to the beginning and displays the formula. Am I missing something? *Note, this is when using a date…
Hello! This seems like it should be easy but I'm having trouble figuring it out. I would like to have the cells in a date column turn different colors after a number of days has passed. For example, if the date is over 30 days, I would like the conditional formatting to change to yellow. If it is over 60 days, I would like…
We have a sheet that collects data from the user. At times we have to ask for updates or corrections. It would be great if there was a way to request an update and have the user be able to send back information and have it update the same row as the original information.
I'm curious if there is any way to associate colors to the values using the Bridge "Update Column" element. The first column in this image is created manually. The second was created using Bridge. It's not in the API documentation ..and is clearly not in the element: Any ideas?
It looks like you're new here. Sign in to post and engage.