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.

How to share data with external users and allow some editing
Hi, I'd like to share a sheet with an external user, and allow them to edit update one column only. If I produce a report, then that will mean they would have to have access to the underlying sheet, which will contain information I don't want them to see. My plan is to set up a sheet which links to my main sheet, which…
Hyperlink in a cell
Hi there, I'm looking at hyperlinking a sheet into a cell. What are the limitations of doing this? (if the sheet is moved or/does the hyperlink expire) Many thanks in advance Scott
Average a column with zeros
Hello, How do you average column and not include the cells with zeros in them. Value 1 Value 1 Value 1 Value 0 Value 1 This column will grow larger and larger as more form data comes in. Thank you
Report on Tasks due including Header
Hi all, Can someone provide me a workaround here. I would like to run a report that lists all the tasks due to start in the next 5 days. But what I need is to include the Phase name, even though the Phase has already started. I have added screenshots of what I have done, but this adds all phases, even the ones that does…
Workflows are not triggering, is this an issue with smartsheet today only?
My workflows are not triggering and I have not had any issues with them on previous days. Is there an issue with smartsheet workflows or a bug?
Private Comments
I am trying to figure out if there is a way to make a Private Comment in Smartsheet? Let's say I have a Published Report that is viewable to anyone with the link; however, I want to make a comment on a line that I don't want anyone to be able to view outside of the original document. How can I do this?
Is there a way to auto-hide columns based on the value selected from a drop down cell?
I have a main grid with several columns and a webform that feeds into that grid. This tracker is used by my team to track several job "types" defined in one of the destination grid columns as "Large Project", Medium Project" and "Small Project". Each distinction has its own requirements, thus making a few of the existing…
Managing contacts is frustrating
Is anyone else frustrated with the contacts management within smartsheet? If I import contacts or add them to "My Smartsheet Contacts" , I am unable to add them to groups. So I add them to group first (email only) but then some I can edit via My Smartsheet Contacts to add their name and some I can't. When I add a name it…
Test log
Can someone provide some insight to creating a testing log? Either point me to an existing Smartsheet template set that can be massaged to fit my testing needs or have a test log template set that you are willing to share.
Using a dashboard as shared by our account manager - users are getting errors below
Multiple users are not SS users but that shouldn't matter since we are sharing a viewable link. Why would we get this error? Submitted a support ticket too and kind of urgent for us to resolve.

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