Smartsheet Basics

Archives for June 2023

Converting a date in a text type to Date type
Hi, I have a column as text/number type with date value such as '2023-06-27 09:02:53' and I want to have another column and convert it to DATE column type. e.g "Date as Text Type" column is a text/number field. I want to convert this to DATE and put in the "Date as DateType" column. is there a way to do it?
Users having issues with accessing published sheets
HI I have had several users reach out to me indicating they are no longer able to access a published sheet. They have been able to access in the past but now they are not. Nothing has changed with these published. Yesterday for one user, I deleted their account and re-added. Once he accepted the invitation, he was able to…
Copy changes from Clone Workspace to Live Workspace
Hello all, We are working on a Workspace for a client and they have asked various changes to be made on their Workspace. We created a Clone Workspace to implement all changes and make sure it works correctly. The requested changes had to do with: Adding new columns to a sheet & update columns order Adding column formulas…
Price modeling
I have a dataset with prices on a dozen different products that need to be grouped by country and analyzed for mean, median, mode, count and range (max/min) in order to establish a pricing model. New data will regularly be added to the underlying dataset. All of these functions could be setup in the base sheet's Sheet…
Intermediate license
Hi everyone, I wanted to know if you planned to add intermediate license. Indeed, if somebody just want to modifie a title of a column or a question in a form, this person must have a complete license. I thinks it could be very intersting if you create two type of license one for modifie and one for creation and modifie.…
Reloading the same form
Hi, I'm setting up a form which reloads after every submission but there's no option to get out of the form without closing it completely. You can just close the form and it seems to capture everything, however that isn't very intuitive for the form user. Is there a way to choose "complete another" or "final submission"…
Extracting data from bulk sheets
Hi all!! I don't know if this is possible - we use Smartsheet for all our clients, so over 1000 people complete a type of exam in their own sheet, and have a linked dashboard (both in theor own folder). We look at their pie chart widget in their dashboard to track how far through their assessment they are. Basically in my…
Why is my automation not triggering?
I have two columns I would like to run in an automation, one contains a check box and the other contains a drop-down menu of text values. I am trying to run an automation in which when I check a checkbox in one cell, it updates the "Status" cell in the same row to 'Complete'. The automation either doesn't trigger or takes…
Dashboards
Does anyone know how to send a snapshot of a dashboard? C levels don't always want to click a link. They want to just see the dashboard sent via email so how can I send the dashboard via email and keep the formatting? Print screen and snip are not great options. Thanks
Form has a contact list field, for the contacts are not pulling into the form
Hi, We created a form to take in change request. The sheet has a column 'Interested Party" and this is a contact list. When i am in the sheet, i can start typing a name and the contact list based onthe spell comes up. This does not work the same in the form. Is there a setting that I am missing?

Upcoming Events

Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。

Trending in Smartsheet Basics

Set Default Value in Form that is NOT a Dropdown Value
Hi! I have a sheet that has two form that feed into it. This is to report on Closures due to Staffing, Weather, and Facilities. One team submits closures for Staffing and Weather, while another team only submits Facilities. When I created this set up I have it so the one team gets asked "Reason?" then they can select…
Email notification Lay out
Recently, I got an inquiry if there was any changes or update made in Smartsheet that made the lay out of the email notification change. Specially the Details part. It use to be on a vertical layout but recently we were seeing that it became horizontally. Is this a recent update with Smartsheet?
Unable To Create Project Using Control Center
Hello community! This is my first time trying to use Control Center so bear with me. I've been tasked with creating a solution within Control Center to provision new projects. I have my project sheet, I have my intake. I created a program and blueprint on the Control Center side. It references the intake sheet and a…

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

Watch video<

Smartsheet Basics

Discussion List