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.

Probably simple question re: parent rows
Hi-- there may be an obvious answer to this, but I have searched high and low and not found it. I simply want to create parent rows that do not include the status features associated with certain columns. In other words, most of my rows include a "Done" checkbox. That's great. I don't want my parent rows (which simply…
Setting up a sheet for KPI's dates in row vs columns
I`m setting up dashboards which will be cascading with roll ups to the executive level. These are operations related data and not project related. In setting up the sheets I had looked at some of the templates and seen that very often they are set up with the dates of the entries running along the top of the sheet heading…
Resource management
Hi Resource management isn't listed in the Gantt settings for a project sheet so I'm unable to create resource views. Can any one suggest a workaround. Thanks Kirstie
Reports Published To A Site
I have a report that I have published to a dashboard/site. I need the users to be able click on the Widget in the site to open the report, mainly so they can view comments on the rows in the reports. I need them to be able to do this without them being granted access to the source sheets. Any assistance or direction on…
Populating Check Box Based on Date Field
Does anyone know what's wrong with this formula? I have this formula in a check box field. I'm trying to check if the Receipt Date is greater than 5/1/18 and if yes, I want it to put a check in the checkbox. What did I do wrong with the formula? Any help is appreciated! =IF([Receipt Date] > DATE(2018, 05, 01), 1, 0)
Highlight Colours
Hello, I have an 'Alerts & Actions' when a row is added to email out many cells. When this email arrives in my staffs inbox the cells are bright yellow. Is there a way to change the colour? - I would ideally like a less bright colour? Any help would be wonderful. Thanks Matt
New Data Not Automatically Added to Charts
How do I (if possible) get my charts to automatically update with new information that's been added to the sheet? I currently have a sheet that has a scoring system based on a 0-100 percentage. When I created the chart I selected all the columns I wanted and included all 5 line entries. It charts just the way I want it to,…
How to setup a notification for less than days
Hi, How can I setup a notification for a column that date is less than days ? like 60 days. thanks ! Nova
Rows of data moving
Greetings to all, At my work we have recently started using Smartsheet. We use it on a simple level, i.e. two or three users can update the same spreadsheet at the same time. We're a transportation company and we use the spreadsheet to schedule our runs and and update current runs after completion. What we have noticed,…
Project plan updates and forms
I am using SmartSheet for a project implementation and want to issue alerts using the Forms functionality. How can I include predecessor information for each of the tasks I want owners to update via Forms? Currently, I can provide the users with a listing of all tasks, however they may relate to a predecessor task that…

Popular Tags

Trending in Smartsheet Basics

Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags