Smartsheet Basics

Archives for December 2021

Automation
When automating to alert someone when a row is added or changed given specific conditions, how can I select two or more specific conditions? When I add specify a second change, it indicates the first OR the second. How can I notify only if BOTH are changed to the indicated conditions?
Resubscribe to an automation email?
Hey all, A critical member of our workflow has unsubscribed from his approval emails. After doing some digging on the forums I have found a couple solutions: -Remove his email from the notification list in the workflow, then add him again -Duplicate the workflow Neither of these work. The workflow still says the user has…
Dashboard - I am unable to get the required data
I am unable to use dashboard widget - what I need is row iteam and against that the answer - but what I am getting is column title
Sheet randomly wiped all data
I have been actively working in a sheet and suddenly all data was wiped. All columns and rows are as if I just started a brand new sheet. Activity log shows the creation of the sheet but doesn't show any of the activity. Wanting to cry over here because hours were spent creating and working on this sheet... Anyone…
Customizing axis labels on line graph
When creating a line graph widget, is there a way that I can customize the values of the vertical axis? I want to scale to the date, but I also only want whole number values and only positive values. How can I modify the labels to accommodate this?
Limit Columns in a Pivot Sheet
Happy Holidays- I am looking to use Pivot to create an updating table that will give me a source to use for a trend line graph for admissions over the last 15 days. My only problem is that I don't know how to stop Pivot from adding columns as the trend gets longer. It may be that Pivot is the wrong tool for the job. Here's…
Share a report/dashboard without sharing underlying sheet?
Happy Holidays reader! I have a question about being able to share a report/dashboard without giving users access to the underlying sheet. The set up: I have a sheet with a form were users use the form to add entries to the sheet. I want users to see ONLY THEIR OWN entries without having any access to other users' entries.…
Using Date Filters with Datatable
Happy Holidays- My company recently added Datatable to our Smartsheet package. I started to develop a sheet that would use a date as the filter to pull data from the datatable. No matter what I do, the filter returns 0 results. Is anyone aware of a known bug with this feature? If no bugs, can anyone help me troubleshoot…
Sheet form errors when using Chrome
Recently an issue has come up where our users are having trouble entering information into forms from a sheet. The autofill function in chrome automatically enters items like email address etc dependant upon user preferences. We have 700 people on our account and sending instruction to them on how to disable or manage…
Full Screen mode as default view
Hi to all! We love the full screen mode and we must say we use it all the time. Could it be possible to make an option to open each sheet in full screen mode? Or, ad the the full screen mode in the view button, in this way we could bookmaks a sheet with a specific view with the option of the full screen mode. Thanks!

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 のご利用を開始するために必要なすべてを網羅しています。
Smartsheet In Person User Group | Raleigh
Connect with fellow Smartsheet mobilizers and advocates! Join us at our in person user group in Raleigh, NC on Jan. 15. This is a great opportunity to discover how other local users are optimizing their use of Smartsheet. *Get inspired: We'll learn from local users, who will share success stories on how they use Smartsheet…

Trending in Smartsheet Basics

Can one cell change cause workflows in multiple grids?
I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1. Here is my setup and what the issue I'm having… Grid #1 has the column that is being updated. Workflow setup on Grid #1 to move the row when the cell is changed to a…
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
Membership/ Access question
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…

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

Watch video<

Smartsheet Basics

Discussion List