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.

Help with SUM function with Duration of Time
Hello all, I have been reading through the forum this morning on how to work around time duration in SS. I used the trusty Travis/Ajayi "formula from hell" to get an actual calculation! yeah!!! My problem is.... trying to SUM the duration column. I have attached a screenshot. I usually use excel... and am not find SS very…
Avoid access to smartsheet when request for update
First of all, english is not my native langage, please excuse my mistakes. Hello all, I have a smartsheet with several external counterparts (customers and providers). I manage the smartsheet which is not shared and nobody is able to reach / open it. I send requests for update with automatic processes. but when counterpart…
Problem with filters on Licensed Users
Hi, Guys. I have a smartsheet with private information on 50 people. Some of them are full licensed users, others are simple users (they use a company license, but they can't create) I want each of them to view only what regards to their names, but when I shared the sheet with them, even selecting to share only the…
Can alerts be sent to a user(s) triggered by a "due date" or an "out of tolerance range" column?
Currently we are using Smartsheet in the raw material quality department of my company for two different purposes: 1) Having vendors/suppliers submit yearly required compliance documents directly into Smarthseet (as opposed to forwarding them to us in an e-mail). We are currently manually sending e-mails each year to…
Adding "Contact" Widget at my Dasboard
Hello, I'm a starter in Smartsheet and try to build a Dasboard for FM KPIs in a Building. I also want to add a widget that displays the building managers (with picture, role, and contactdata - max. 2 Persons). Enclosed you find two pics I found on other Dashboards. Witch widgets where used therefore? Or what do I have to…
Need some assistance on Reporting and Calculations
Would love the communities advise on how to best solve this. I have an Aging Report that I need to provide the totals of the top 10 based on the $ amount (top 10 largest $ amount) and then the top 10 oldest items. How should I best get this information which will change from week to week?
how to delete multiple unaccepted invitations?
Hello, I have a question about user management I would like to delete 50 unaccepted invitations. Line by line is long. Is it possible to do it all at once? Thanks
Format reports viewed on a Dashboard
Is there any way of formatting the reports added to a dashboard? I have added a report and the width of columns seems to live their own life. Can I change this in any setting that I have missed?
Update request report
Hello, Is there a possibility to show all update requests of all planning sheets in 1 report? Kind regards Stéphane
Using forms to update a row
I would like to use Smartsheets as a check-out/check-in for handing out laptops at an event. I want to use the forms to update a row when the laptop has been handed out and then when returned. Thanks

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