Smartsheet Basics

Archives for January 2021

Form Sharing
Hello, I know there is a security option in Forms to "Require people to login to Smartsheet to access this form" but is it possible to share only with intended users, or just shared users in the same Workspace? To get people to login is not the best security since anyone can create an account, and if I want to restrict the…
COUNT IF TWO CONDITIONS ARE MET
Hi! I have this formula to identify if all my status are "Completo" then turn the cell "Completo", but if a children status is "Sin iniciar" then the status must stay "Sin terminar". But I want to include another status in my column "Condicionado", so I want that if all my status are "Completo" or "Conditionado" change the…
Cross Functional Formula skip cells
I created 12 cross functional formulas in my sheet. They were working fine for months. Recently they do not populate in all of the cells. When I check the sheet the formula is pulling from, the information is present but it does not appear in the sheet where I need the results. I have tried the following but I am not…
Trouble with Move Rows automation workflow
Hi, I'm having trouble with the 'move rows' automation workflow. I've used it successfully before, but for some reason it's not working with the 2 sheets I'm using this time. I have an 'open requests' sheet and a 'completed requests' sheet. When a set of criteria are met, I want rows to move from the open requests to the…
Has anyone successfully triggered an alert using only a checkbox as the requirement?
I created an alert to trigger when a check box is "Checked," however, the alert has still not arrived in my email, including the spam folder. I wanted this to print out a request for our working files without manually creating an "Update Request" each time I need one. I have tried the trigger as both "When rows are…
Burndown chart?
Hello everyone! Does anyone have a burndown chart template that they would be willing to share? thanks Steve
how to automatically add a date when another cell value is added
I am trying to add in a formula to automatically add the date in the "date completed" cell when the "completed initials" drop down value has been added. What is the correct formula to make this work? I want the date to automatically populate when the job has been completed.
Form Files
Hello, I understand there is only one area in the spreadsheet to hold uploaded files, however I am wondering if there is a way to have more than one section on an actual form for files to be uploaded. If the file section is noted as required but does not have a quantity of files required, they would be able to surpass the…
Project Dates
I am having difficulty changing project beginning and end dates. Looks like I am not the only one. Is there a way to do this without adding a column and formulas? For a program like this I would think there should be a easy fix. Is there a way to disable the parent dependency?
Reports - Some fields can be updated?
Hello. I have created a report, and I noticed that some fields can be updated and others cannot. For example: I can update: task descriptions, start date, Health, percent complete, and notes/comments I cannot update: End date, task owner. Any idea where I can change this update everything or why it working like 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

Conversations
When I send a conversation on a sheet and put @ and the persons name, do they receive an email with the comment?
Template Downloads
Hi, I've watched number of training videos, specifically to set up PMO. I followed the instructions to download a template set, but it always adds it to a workspace, not the sheets folder. In fact if i download anything it adds it to a workspace, not sheets folder. What am I doing wrong?
Moving Columns - Editors cannot share
Hi Brain Trust I have a sheet …hahaahah I have 4 editors cannot share - who in the last 4 days have somehow moved several columns to the back of the end of the sheet - we can see in the activity history that the reordered the columns - yet when we stand there and try get them to replicate it they cant How is this possible…

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

Watch video<

Smartsheet Basics

Discussion List