Smartsheet Basics

Archives for January 2023

Can we create a dashboard Template with format fix
Can we create Smartsheet Dashboard with defined format for Metrics, Graphs etc. when we change the source of the data, it should not change the format and it changes the values based on the sources linked to it. Or can we replace the existing Metrics values by changing the source and not the format?
How to re-arrange metrics from Smartsheet dashboard
how to rearrange a selected metrics from Smartsheet dashboard, Suppose we create a dashboard with Metrics A, Metrics B, Metrics C etc... and how to rearrange Metrics A Metrics B Metrics C to rearrange to 1. Metrics B 2. Metrics A, 3. Metrics.
Elapsed duration is calculating one additional day
if I use e10d in duration column to ignore non working days its calculating one additional day, for example if I set the duration as e10d and the task start date is 01Dec2022, the end date should be 10Dec2022 right but its showing 11Dec2022 as end date.
Can I Sum Children Rows if The Values in the Children Cells are a Function of Something Else
I made a unit price column in my sheet that auto-populates prices for specific products. I would like to create a cell that adds those unit price values for a total price value. I have not been able to do so with them being a function of data and not specific data I typed in one by one. How can I do this?
Transferring Ownership of Multiple Sheets/Reports/Dashboards at once
Hello, I've got a scenario where I helped a user (let's call him User 1) create a process, however, he (User 1) has switched positions and it is time to reassign ownership of things to another individual (User 2). Between me and the original user (User 1), we created all the sheets, reports, and dashboards in the…
I created a form for people to request services how do I get responses saved to correct workspace?
I created a operations request form where the responses are saved in workspace according to the correct year. Since it is the new year my responses are going to the 2022 workspace instead of 2023 workspace. How can i set up the workflow or am I just supposed to send the link to workspace to everyone in my department? Thank…
Is there a way to rearrange sub-tasks under a card once they have been added?
Also, is there a way to pull a sub-task from under a card and move it under another card?
Managing Multiple Weekly Update Requests
Hi - Wondering if anyone here can help. Our IT organization has a master source sheet tracking all the project requests for the team. Requests are made through a Smartsheet form which inserts a row on the master source sheet. As part of the development request, the PMO send out weekly automated update request to each of…
Update Project End Date if Tasks Finish Early
I have a project with multiple sets of activities grouped by "area". I'm using dependencies to determine the start/finish dates of tasks throughout. I have a milestone at the end to give me the "finish" date (essentially "when all prior tasks completed"). Some of the tasks later in the project can be completed early, but…
Card View Sub-tasks: rearranging and moving sub-tasks
Is there a way to rearrange sub-tasks under a card once they have been added? I currently cannot do this. Is there a way to pull a sub-task from under a card and move it under another card? These 2 features would help a lot!

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

Question about what Data Shuttle Run Options
Hello, I am not sure i understand what the scheduler means in the data shuttle I have set up. Does the below mean that my scheduler will run every hour from 5 am to 8 pm each day? I need it to update often but not sure if this will do it or not. Thank you to those that are smarter than me :-)
Renewed License but Unable to Edit Smartsheet
Hi, Our team has just renewed our Smartsheet license after the trial period, but we are not able to edit or enter data. What can we do to be abe to edit and enter data again? Thank you.
Report adding and removing sheets
I have a report that consists of 27 sheets. Shared sheets and report with 3 people. These 3 people do not have the ability to add or remove sheets in this report. Is that normal? I would like for them to remove sheets as they complete a project. Attaching an image - the selection option is grayed out for them.

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

Watch video<

Smartsheet Basics

Discussion List