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.

Report using multiple sheets
Hi...I would like to build a report from 2 sheets. Taking most of the columns/rows from the first sheet "Summary View" and then just one column of data for the color the RYGB color status from the "SP Automation -Internal" sheet. I have tried to add this missing data point into the "Summary View" sheet but I am at the max…
Send a link to a report to users that have tasks due that day
I'm not sure what the best work flow is for this but here is my current setup: * I have a task list with all tasks for the duration of a project. * I have reports that list all tasks due within the next day or week for the "current user" * Currently users get alerts for every task that is due on that day (multiple alerts /…
Automation in Smartsheet-Responding to automated updates
I have workflows that automatically send update requests to my vendors when a task is 48hrs from its completion date. However, when they respond it goes to automation@smartsheet.com, and not to me where it should be? How can I change it??
Dashboard Metric Sheet Index Collect and Week # format
We are having some issues with our dashboard linking abilities. We have a cost summary sheet that is updated weekly and our current set-up involves the values entered in the cost summary linked to a dashboard metric sheet with the "today" function tied to the week # function in order to have the $ values automatically…
Numbers and Dates in the same column
Is there a way to have numbers and dates in the same column? When entering a number less than 100 in a Date column I get a date. When entering a date in a number column I get an error. Is there any way around either of these? I need the numbers and dates in the same column for formatting reasons.
Saving different default filters for different views?
Is it possible to apply a filter to the grid view, but not to the calendar view? I am trying to filter out items that have been marked as "complete" from the grid view, while keeping them on the calendar. I know I can toggle the filter on and off, but was hoping there was a way to save this as a default. thanks!
Formula to track cell changes
Hi, I would like to present in report only rows which some of the cells has changed (Status, Due date, comments). Is there a formula to track cell changes? Thanks
Is there a way to easily share Sheet with all "Assigned To" contacts?
Is there a way to easily add all the contacts from a Sheet's "Assigned To" column into the "Invite Collaborators" field when trying to share the Sheet?
Link Project Management Pipeline to Key Account list
We have two sheets that need to work together... 1) One Sheet is for our Customer list. 2) The other sheet/s are for projects. Both have separate functions obviously, but need to integrate with each other. What we want to achieve is for our Sales Team who may be following up a Customer, to know of any projects that the…
UK Date Format
Hi All, Most of you know by now that since the Smartsheet outage incident there is a problem with the date formatting. I'm surprised to see that the issue was reported on the 31st July and until now (2nd August) this hasn't been resolved. Now, after resetting browser cache, cookies and personal settings on the Smartsheet I…

Popular Tags

Trending in Smartsheet Basics

Can the Smartsheet Calendar App send a notification when an event is added or updated?
Wondering if it is possible to send notifications via Smartsheet when an event is added or updated to a Calendar in the app…
Alert Someone 1 Week Before Due Date
Hello Smartsheets Community, I'm sure this is a dumb question, but I can't figure it out and need some help. I need to create an alert 1 week before dates that are entered in a date column field on my sheet (example below). I tried creating an automation, but I don't see where I can select # of days prior to a date. Any…
CAPTCHA within a Form
When I turn on CAPTCHA within the Form setting, what should I see. I was thinking that with this ON, a user accessing the Form would start seeing CAPTCHA type windows and questions, however, I do not see that happening. What am I missing?

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags