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.

Change Dropdown Items in Form
Is there a way to automatically remove a dropdown option from a form after it has be selected a certain number of times? I have a registration form and have people selecting a time slot and after that time slot has 6 participants I want that time slot to no longer be available.
Contact field on form not working from web, ok on mobile
I have a form that has a contact field (email). It's a required field and the form just recently started acting glitchy. When accessing the form from a web browser, it does not allow the user to type anything and they can only select from past field values. When accessing the form from the mobile app, it works as expected…
Report - How to sum the values.
Please, I'd like to sum the values from all rows in a column and see this result as a last row. Is it possible to sum values in a Report?
Last Modified Date on a Smartsheets Chart
Hello, I've built a chart seen below. I'm trying to include a last modified date somewhere on here whether i hover or have it just displayed on the chart. Ive got that information in the report, just not sure if it will show on the chart. I'd appreciate any feedback! Thank you :)
Really LIKE the new sidebar
It seems that the new sidebar is being disliked a a lot. I'm wondering why so much. I've always found that there is so much in Smartsheet that is all over the place and have not used the features because of this. Knowing where to go and you know you've seen everything is good in my opinion. The summary section is fantastic…
Customer Success Management Template Request
Good Day All, I have been seeking desperately to look the customer success smartsheet referred to in this document (https://www.smartsheet.com/sites/default/files/Customer-Success-Management-Solution-Guide.pdf) However when I connect Smartsheet it seems it was removed. I am hoping there was someone on this community that…
CALENDAR VIEW Date is not showing accurately
Some of our shared users are having trouble with the date showing up accurately in the Calendar view. I cannot seem to find a setting that would allow this to be changed. I have tried refreshing the screen, closing the browser and restarting it. but still they see the dates with Month 7778 example shown in screen shot…
formulas
When I am trying to add several variables using =sum( formula and scroll to locate other variables, my formula is cancelled and I receive an error code. As if I can only use variables/amounts on desktop screen and not above or below.
Activity status column based on due date and % completion
Team, It will be great if someone can help me to Color Code/Highlight the activities in my smartsheet based on target completion date & % Completion column that is manually updated. What I would like to do is: IF target completion date is in the past & % Completion is less than 100% mark it as “PAST DUE” IF target…
Reporting on Tasks Past Due by Person
I'm looking to collect ongoing data/statistics on how many tasks reach past due. I would like to collect this by person assigned and across all projects and then by month. Any suggestions on how to tackle this using smartsheet?

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?
Multiple Users in Grid
Hello. I am trying to create a tracker where there will be multiple users in a Grid sheet and everyone will be adding in a new line at random and same times. Is there a way I can create it where people's work won't save on top each other? Or is there a live view on Smartsheet where other people can see that someone else is…
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags