Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Most Recent Form Entries Metrics
I have a Sheet which is populated by a form, and then calculates prices based on the entry responses. I want to create a metric on my dashboard that displays the pricing information for only the most recent entry, any tips? When I tried linking it to the cells in the top row, it seemed to be a link to that particular cell,…
Due Date dependent on predecessor AND allocation %
Hi, I'm trying to get end dates to change based on estimated hours AND allocation %. Is that possible? How do you do this? Thanks!
Contact Columns not available in POwerBI when multiple contact enabled?
Whenever I enable a contact list to allow multiple contacts (New feature Oct 2018); the power BI column display balnk for all records. Happens after enabling this in the columns and adding multiple contacts in any cell.
Chart in Dashboards
Hello, Thanks to all for the wonderful help in the community! It makes everything so easy to use! I do have a question about something I was not able to figure out. I want to make a pie chart in a dashboard that reflects the status column in my sheet. Literally all I need it to do is have "Not Started, In Progress,…
Using a sheet to assign a project number
We use google docs currently for our company to input data about clients, and be assigned a specific project number. We have ~30 employees in the project book pulling these file numbers at any given time, so we like the transparency of seeing who is on what line, so as not to overwrite their data. We then take that project…
case number is 03069236
Dear Tech Support, Is anyone answering tech support issues...? Regards
Calculate Calendar Days from Start Date + Workdays
I would like to calculate the # of calendar days given the following information: * Start Date * Work Days I know the "workday" formula will give me the end calendar date but I don't want the actual date. I am looking for the # of calendar days. For example: * Start Date = 1 Jan 2019 * Work Days = 11 * Resulting Calendar…
Data change before they're approved!
Hello! I'm a new smartsheet user and I've been testing it for the past 2 weeks to decide whether to use it or not. My problem today is when I send an update request to a user and set an approval request to myself, the changes made by the user get registered in the sheet before I approve the changes. So whether I approve or…
Reports on the mobile
Hi, It seems like when opening reports on the mobile in order to add one of the tasks fields, the form is opened with all sheet's columns instead of those who are only part of the report, do you know anything about it or if there;s a workaround ? need to update tasks 'assigned to me' (using this report) from the phone..
Donut Charts
Is it possible to create a donut chart that includes a total amount in the middle? like the one attached bellow?

Popular Tags

Trending in Smartsheet Basics

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags