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 Smartsheet Basics

MS Project Import Question
Hello all! I did a search, but can't find this exact situation in the community. I'm currently creating and updating a schedule in MS Projects and then importing it into Smartsheet. I've found that when I'm in the schedule in Smartsheet, select "import" and choose the MS Project file, it seems to create an entirely new…
Card View: Can't sort by desired category
I would like to use card view for one of my sheets - and sort it by the "type of service" that was performed on our equipment. For some reason, I am able to sort my cards by literally every category but that one. The column is a drop down menu. Is that the reason I am unable to sort by that category? Not sure why I…
Selection Committee Ratings
Hello: We are going to have a selection committee of 4 that will be reviewing 5 candidates based on pre-established criteria. The selection committee will submit their reviews through a Smartsheet form (unless you think a different method is better). There will be a total of 20 reviews: 5 candidates x 4 reviewers in the…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List