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.

Adding Location column to web form
I know the apps have it but is it possible for the web version of the form to include a location column? I know web is perilous especially from a desktop with proxy and such. But many many many phone web forms now just straight ask for permission to use location. I have a lot of special requests to track location on form.…
Contact List field type in forms
Is it possible in a form to create a contact list field type whereby the user is able to select a contact from their gmail contact list to populate that field in the form?
My first post: To whoever needs to hear this + working parents... WE GOT THIS!
I'm reporting live from Day #5 of school closure as a working mom. Want to learn about how I digitized my daughter's day in Smartsheet amid COVID-19 school closure? Keep reading!... Spoiler alert, also includes these gems: A confession, a Hunger Games reference, my daughter on a motorcycle, a 28 minute demo on YouTube of…
When I try to download Project Templates I get a message saying I already have them.
I choose 'save as new' and nothing happened. My sheets list does not show any templates. How do I download the templates?
Automatic report creation with custom template
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. For each new answer on the form, a new report or Dashboard must be created, which must have the format below. I wonder if there is any tool, API or integration with any other platform that would make this possible? Any help is much…
Gantt view with multiple assigners
I have a project with dependencies and multiple assigners enabled. I would except that the tasks duration will be reduced by the number of ppl working on the project, but that's not the case. It seems duration column and the gantt view ignores the assigners feature - the duration stays the same even when selecting multiple…
Best Practices of archiving sheets
Hello, I currently use a form to populate a sheet for any new sales leads. We're at the end of our fiscal year and I'm trying to archive all old leads and start a new sheet. I want to know about some best practices of achieving this. I was thinking about the following ways: Move all open leads via automation to a new sheet…
Change Color of 'Color by Column' on Calendar App
Hello! Is there a way to change the colors set by the 'Color by Column' design option on the Calendar App?
gant estimation and consumptive
how can I have estimetion and consumptive date in a project gant?
ODBC data pulls US date to mail merge
I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as date columns are switched from UK format (DD/MM/YY) to US format (YYYY-MM-DD) and the only way I can find to resolve this is…

Popular Tags

Trending in Smartsheet Basics

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags