Smartsheet Basics

Archives for December 2022

Collaboration with shared sheets
I need to share sheets with multiple users, some need to have editing ability, some just need to be able to view the sheets. But all users need the ability to collaborate with row and sheet comments. I am sharing multiple sheets, so I am trying to decide the best method for sharing. I have tried Dynamic View, Workapps, and…
keep a copy of the first value written to a cell.
I want to copy and record the first cell value even if the first cell value changes. I am writing a program to generate PO#'s sequentially only on certain lines, so I can skip category headings. I have this part down well. See the formula here: =IF(Bucket@row <> "", "A****" + "00" + IFERROR(MATCH([Row ID]@row, COLLECT([Row…
Automation Workflows to add multiple Multi-Select field values
Is it possible to have multiple automation workflows that will simultaneously or sequentially process to add multiple values into a single cell? Here's my scenario. I've got data that gets entered into a sheet that has the potential to be missing elements. The hope is that my users will correct those gaps, but once…
What is the best way to update data between two sheets w/o having to do it manually?
I have a Project Tracking Sheet for all of my team's projects. One of our repeat projects is rollout of the inventory module in our company's primary software. Since we are a shared services group owned by a PE firm, the processes around this implementation are always the same, we just have to track each separately since…
Need to update a sheet based on activity completion on another
I have a sheet that needs to be updated after an event date is passed on another sheet, while also calculating the event hours on a different sheet. HELP! Thank you
Import from .mpp file not perfect?
Recently have been testing out functionality within Smartsheet to compare to other products that are very similar and there seems to be a critical issue with the import functionality from MS Project .mpp files. See below from the same .mpp file: PCH-36 should be a parent on the same level as ASC/OQR, the section is…
Unable to create a group on Smartsheet getting an error message.
Date stamping the latest comment?
Is it possible to include the date with each comment in the Latest Comment column?
Testing Alert Someone Automation with Attachments
Hi all, I just created an automation to notify someone when a new row is added. All rows on the sheet have attached sales invoices. After creating the new Automation I tested it out on the first row of the sheet, which has an attachment, and had it send the notification test to myself instead of the normal recipient. I…
Report suddenly stopped showing any rows
I created a report that points to many different Workspaces. I used filters to control which sheet names are shown on the report. Yesterday this report was working perfectly. This morning it's not working. Any clues?

Trending in Using Smartsheet

Data Shuttle Error "Specified Key Does Not Exist"
In Data Shuttle, I have a workflow that is producing the following error: Unable to add rows to target sheet : UNKNOWN: The specified key does not exist. (Service: S3, Status Code: 404, Request ID: 7FED8H5R7Q5AXB87) This workflow has been operating fine for months (runs twice a day) with no errors and this just started…
Reupload Data with DataShuttle
Dear All! I would like to create a tool which uses Data Shuttle. Basic idea is to ask user to upload attachment (via a form) which would trigger a data shuttle and info in the attachment would go to a transition sheet from where it would be moved to the target sheet with automation. It works nicely, however, I need to…
Dashboard reports not showing on published dashboard in SharePoint
I have embedded a Smartsheet dashboard in a SharePoint Online site. Some reports show just fine, two do not and I can't figure out why. I published the dashboard and grabbed the embed code. Used an embed web part in SharePoint to embed the dashboard. Two reports show fine, the other two have errors. There is nothing…

Smartsheet Basics

Discussion List