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 Notification
I cannot get a notification to fire to the name in the "Assigned To" column when a new row is added. Screenshot is attached. Automation Permissions are set to "Unrestricted" The contact is shared to the sheet My personal settings are checked to include my changes in sheet notifications. And, I checked the SS status page…
Gantt view on a dashboard report
I'm trying to include a report with it's corresponding Gantt chart on a dashboard. The report is set to open on today's date. However, in the dashboard the Gantt chart starts in June and I can't even scroll back to today's date (see attached snapshot). Can anybody help? Thank you.
Capturing user/email addressing via form
Relatively new smartsheet form user here. Is there a way to create a field that would allow the entry of a name in one column and an email in a second column and have a user input multiple name/email pairs within a single web form? Essentially, we are creating a web form for training sessions and there are a number of…
Using Collect function within Large function
Hello All, I am trying to nest a criteria within the LARGE function. I have 2 levels of children within my sheet and I have placed a hierarchy column so I can select just the children with a hierarchy ranking of "2" for the LARGE function. My formula below, but it is throwing errors. Any help would be appreciated!…
Managing Alerts & Reminders
Recently there have been a lot of changes to managing alerts. They have been very good changes. However, today I noticed that I did not receive an alert that normally would come to me. Upon checking I discovered that menus have changed. There is a new heading called "Automation". This took me a while to figure out. I…
Formula help
Hi, I am trying to count the total in a range on another sheet if entries fall within a certain date range (30 days) and are a specific name "Missed Hours" I have the following formula but cant get it to work: =SUMIFS({Help Desk Range 1}, <=TODAY(), {Help Desk Range 1}, >=TODAY(-30), {Help Desk Range 2}, "Missed Hours",…
Issue with chart widget on dashboard
I am pulling multiple reports into a dashboard. I am then making charts from these reports. One of the reports, will not measure the same as the others even though the criteria is the same. For example, the bottom % are showing 1% multiple times along the lower horizontal of the page. I want it to match the others which…
Emailing a contact chosen on a dropdown
Is there a way to email a contact identified by a dropdown list?
Phone support
Hi, is anyone aware if Smartsheet offers phone support in Australia when needed? regards Michelle
Forms data populating worksheet
I have created a form and I have it set to populate at the top of the worksheet. I have a summary section at the top of the worksheet so I can show all the in progress, completed, etc. for all the contracts. I need the form data to start below that summary level on row 7. How do I set this up to happen. When I set it to…

Popular Tags

Trending in Smartsheet Basics

Is there a way to have a form update existing information?
We are conducting an audit of our I-9s. In order to do so, we have pulled an active list of all of our employees (EEs). These EE names are already on the sheet. In order to effectively complete the audit, there are specific things we need to check for based on the expiration date of the I-9 document that we have on file.…
Pulling info from Reference Sheet based on Date
Hello, I am trying to pull the information I need based on a date on the referenced sheet. Without this criteria the formula works great. this one criteria is not working. I created a helper column on each sheet. on the reference sheet is a formula to calculate the month number for that row, and then on main sheet is a…
Need help with Data/Chart Widget
I am working on a dashboard with various data points and had zero issues until I started the most recent widget. I am pulling from a simple report that has a list of staff members and their assigned work spaces. I keep getting an error that says the data cannot be charted… What is the limitation here? I made 4 other…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags