Smartsheet Basics

Archives for August 2019

Locked out of my account
Locked out of my account. It seems they assigned an administrator to my account and they have locked me out.
Can a non-licensed user edit Dashboards?
If I build a Dashboard and add a non-licensed user as editor. Will that person be able to edit and make changes to the Dashboard?
Portal Security
Is there a way to password protect a portal without making someone sign up to have an account with Smartsheet or making the link public?
Cloudflare
Anyone else having issues with cloudflare when editing comments? Trying to fix some code i miss-submitted and can't change it. Basic stuff too, just missed some parenthesis.
Parent Row formula for Max date + 540 days
I'm trying to use a formula in the Parent row of several date columns that will: 1) give me the MAX date from the child (anywhere from 1-12 rows) 2) add 540 days to that date (from #1) This will work using: =MAX(CHILDREN()) + 540 Except if the child row is blank and then I get the error message #DATE EXPECTED I've attached…
Multiple Email Address Entry Form Field
Hi I have a created a form, I would like the client to fill the field- Point of Contact- which is an email address. How can one enter multiple emails in a single form field? Any help is appreciated. Thanking you, Regards Saumya
If than statement
I need help with determining the right formula - Scenario: If the value in colum 1 row 2 is "word" , than multiply (column 2 row 2, column 3 row 2, etc) Thank you in advance for your help!
Automatic email notification through forms
I created a form which includes a text field for the person's email address. I want to create a workflow to trigger sending an email to the person when a specific field is changed. However, the person's email is NOT part of the contacts. How can I tell Smartsheets to email the person that a change has been made? There does…
calendar view date is all screwed up!
I seem to have uncovered a glitch. The calendar view is making the year 8148...even with all the advances in technology and medicine I don't think I will be around in that year...I just want to see 2019 right now, and going forward probably 2020 when we get there. PLEASE HELP fix this.
Date calculation for next week
Hi, I want to run a report that will return all rows for tasks that need to be worked on next week. So that will include tasks where the start date is next week, or the end date is next week, or simply tasks that are ongoing through next week, with neither a start or end date occurring during the week. I have a hunch this…

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

Are text fields and checkboxes not showing in your Dynamic View Detailed Views pane today?
Hi everyone, in several of my Details Views for multiple Dynamic Views, text fields and/or checkboxes that are configured in the Dynamic View settings are not appearing in the Detailed View. Is anyone else seeing this today? I've not updated any of my configurations lately and don't know how to explain this! Thanks!
Creating a folder in SharePoint from Smartsheet and naming it based on row data
I'm a Power Automate Novice and I'm not experienced in expressions. I am building a data flow in Power Automate to create a new Sharepoint folder when a new row is created in my smartsheet. I can get to the stage of creating a new folder however I would like to name it based on cell data in the row. I have tried to use the…
Graph Question
Can someone tell me how to get rid of the 120.0% max on this graph? It is always going total 100% and never any more, so I would like to use more of the space for graph display purposes. I even tried reducing it so that the largest value was 99.999%, thinking maybe being exactly 100 would cause the next "level" to…

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

Watch video<

Smartsheet Basics

Discussion List