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

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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

Watch video

Smartsheet Basics

Discussion List