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.

Roll Up Works REPORT only partially
Hello, I know that reports have been an issue, but I think I have a strange problem. My reports are not refreshing with the latest data, even hours after the Roll Up sheet (on which the reports are based) is updated. When I go to my Roll Up Sheet (on which the report is based), and scroll all the way to the right (as if I…
Auditing Workspace Permission Changes
Is there a way to audit what changes were made and by whom for a Workspace? The activity log feature seems to only apply to sheets, dashboards, etc. Use Case: Permissions to a workspace have changes. I want to know who made the changes and when.
About Time Calculation
How can we calculate time between start date and finish date? I want to know by hour and minute format?
Sorting by Date in Exported Excel File
When I export a sheet (Gantt Chart with timelines) to Excel it doesn't seem to sort (e.g. by date) all the rows when indented Task Names are present. It will only sort the highest level Task Name, but I would like to sort all the rows regardless of the Task Name hierarchy. Is there a solution to do this, or possibly a…
Smartsheet Mobile Apps - New Features Study
Hello everyone, We’re working on exploring a new feature to improve the Smartsheet mobile apps. We’d love to chat with a few of you to understand how you use our mobile apps today. If you’re interested, please sign up on this form here: http://bit.ly/2XpJz6z We will reach out to you soon! Thank you, Arjun Lalwani - Product…
Ignoring blank cells with INDEX and COUNT
Hello, I had some fantastic help from Andree with the first part of my sheet, but i'm having trouble to get the below formula to ignore any blank cell in the column. I've tried ISBLANK.....but I cant get it to work... =INDEX([Generator Location]:[Generator Location], COUNT([Generator Location]:[Generator Location])) Hope…
Web form field not self populating in email confirmation
Hello! I am hoping for some guidance please. I set up a web form early last year to allow customers to populate my smart sheet to get purchase orders for transport trailer services, the smart sheet would then give a confirmation email with the self populated order number listed. It saved me so much time and now its stopped…
Pull data from excel and update Smartsheet
Hi everyone.. I am new to the community..so hopefully my question is not too stupid :D I am currently using Excel to calculate a value by using the normal distribution formula. I would like to pull this value from excel and then update a cell in Smartsheet. It is an on-going exercise so the fetch should be done regularly…
Integration SS Vs Gforms
Hi everyone... I'm making an integration between SS and GForms, but i need to bring the PDF attachments people upload in the form into Smartsheet. Is that possible??
% Concluído x % Planejado
Olá, como fazer para criar 2 colunas com calculo de % de conclusão? Eu precisava controlar nos cronogramas de projetos o "%" concluído x o "%" do que havia sido planejado, como tem no project. Alguém consegue me ajudar?

Popular Tags

Trending in Smartsheet Basics

Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags