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.

Totaling up Days between Dates
Hello, If someone could assist me please that knows how. I am trying to get the total days calculated automatically between two dates. i.e 1st Sept 2019 to 15th Jan 2020 - How fo I get the total days calculated. Do let me know please. Thank you
Automation Notifications
I am struggling with the new Automation Notifications as I found the previous arrangement much easier to set up for simple alerts and notifications. I want to set up a daily notification that gives me only new comments that have been added to a sheet. At the moment I seem to have to get all the attachments, all the sheet…
File attachment counted as a change to a row
I currently have two workflows set up: (1) Payment approval request after an event: employees submit request with invoices attached as a file for approval (2) Payment approval request before an event: employees submit a request for an approval, the request gets sent to a supervisor, and once the supervisor approves, an…
Relational Database?
We're pretty excited to start our Smartsheet journey; the functionality looks amazing! I'm struggling to wrap my head around how to make different sheets related to each other. Let me give you an example of what I want to achieve, and perhaps someone can point me in the right direction. Imagine operations has a long list…
Child Text Indented formatting
When you have a Heading Row and Rows below that are Children of the Heading Row, is it possible to have the text Left Align and not be indented? Thanks, Tm
iOS app allows editing of some dates but not others
I’m traveling this week and only brought my phone and tablet. I downloaded the app assuming I’d be able to use it to edit my schedules, but for some reason some date cells are editable and others aren’t. As luck would have it, the active date cells are the ones I can’t edit, the “planned” date cells, which are permanent…
Voting on a Worksheet
I have a sheet that are shared with a group of 25 members, which contains multiple line items that we are currently collaborating on. The purpose of this sheet is to collect the items and publish a requirements document. Part of the collaboration effort is to get all users to cast their votes against each line item so we…
Dynamic Dropdown
Hello, I maintain a Resource Tracker which includes multiple Resource Names and Vendors. Resources are added and removed on a daily basis. I created a Forecast Tracker for each workstream to update on a monthly basis (total of 12 Workstreams). I'm trying to find a way of keeping both dropdowns 'Resource Name' and 'Vendor…
Rich Text Widget
Can text only be entered into Rich Text Widget in edit mode? I was hoping there's a widget that we can use to capture notes live in a mtg when reviewing the dashboard. Suggestions?
Recurring Update Requests until task is complete
I have a workflow where a contact is sent an updated request when they are added to the row. What I would like to know is how to have that update request sent regularly (daily, or weekly) UNTIL they have submitted the update request. Then I don't need them to get the update request anymore. Is there a way to do that?…

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