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.

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?
Form - Column data entry
I can't believe this isn't asked more often...any way of using a Form to populate data into a new column, rather than a new row? Apologies if this has been addressed previously.
Multiplying Formula Issue
I am looking to multiply a simple "quantity" times the "cost each" into a third cell. I created a formula but cells that have no entries in the quantity and cost cells yet, have totals as $0.00 in this column. I played around with the IF statement but had no luck. I do not want to see a column of zeros.
Web Content in Dashboard Not visible
Web content in Dashboard is very good feature of smartsheet but it is not visible in smartsheet mobile app. When Mobile application will be updated ?. We mostly tracking our activity on Mobile App.
convert a fraction to a decimal so it can be shown as a %
Is there a way to convert a fraction into a % without having to do it longhand (as in having two columns with fraction values to then present the sum with % formatting). Thanks in advance.
Working Days in Dependency Settings with Predecessors
I currently have weekends blocked out in the dependency settings/working days. However If we get behind on the schedule and decide to work a weekend to catch up, how do I add back in a single weekend. I use predecessors to keep the project in the right order of operations. If I manually fill in a date on a weekend and…
IF STATEMENT
Hi. I have two columns : Deliverable status and Task status and I have the following conditions applied to the task status column: 1. If deliverable status = reported or shipped, then task status = complete 2. If deliverable status = awaiting results, then task status = ongoing 3. If deliverable status = not required or to…
Unable to allocate task to user
Hi there, I have a task owner column (formatted as Contact). It seem very random on which users it will look up so I'm having to 'Allow' non-users a lot. I thought it might be change, where SmartSheet isn't allowing allocation to a non-licensed user however it sometimes won't pick up licensed users as well. All users have…

Popular Tags

Trending in Smartsheet Basics

Remove workspace shared users from 1 sheet
We are working on setting up our Career Reviews in Smartsheets. We have a group of all staff that has access to all sheets in our workspace. I want to remove them access from just the Career Review Sheets. When I do that it says it will remove them from access to the entire workspace, which is not what we want. The only…
Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags