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.

Referencing Data across Many, Many Sheets
What is the best way to do a SUMIF for data that's spread across ~50 sheets? This cannot be done with reports. My data involves how many hours our clients work in each state. There is overlap because a client may work in more than one state. Each of our 50 state sheets shows which clients work there and how many hours they…
Using <=/>= in an Alert
Hi - I am trying to set up an Alert for when a column gets to greater than or equal to .75. When specifying a change, I can only select existing values. When I have typed ">= .75" I have not gotten any updates when that change is met. It makes me believe that typing in "<=" is not valid. I have looked through the community…
Strikethrough font
How can I Strikethrough only portions of a sentence. Appears that you can only Strikethrough the whole line.
Team Charter
Hi, I am looking for a template for a team charter. I found a Smartsheet template when performing a Google search but I am unable to locate it. Would anyone be able to provide a copy of this template or something similar? See attached screenshot. Thanks!
Count All Rows/Entries
Hello! I want to reflect the total number of entries from a form on a dashboard. Is there a way to do this? Count the number of rows? What formula would that be?
Successor needs a Hard start on a Monday following predecessor
Is there a way to set up a SUCCESSOR activity to have a hard start on a given day of the week? I am in the process of setting up a schedule that requires a SUCCESSOR activity to start on the Monday following its predecessor, regardless of what day of the week that predecessor activity ends on.
Limit the Resource View data
Hi Team, Wondering if I can 'limit' where the Resource View data is pulled from. I have several project sheets - which all work great into Resource View, however I'm trying to create a separate Project Sheet to fulfill a calendar requirement, but do not want THAT project sheet to 'count' towards the allocation - how would…
Sales Pipeline Template
Hi I downloaded this template, it consists of 3 sheets, Dashboard, Report and Sales Pipeline. The instruction PDF seems to indicate that the Sales Opportunity form, created within the Sales Pipeline sheet, is the method for getting Opportunities in to the Sales Pipeline. Extract from ODF The Sales Opportunity form is how…
Why won't durations parent rows in lower levels of multi-tiered hierarchy on project schedule roll u
I have a project schedule with multiple levels of parent rows. In the Duration column, the 2nd and 3rd tiers of parent rows do not subtotal the children underneath them. Is there some other setting or consideration for getting this to roll up properly? Will Smartsheet allow a 2nd or 3rd tier parent row to subtotal the…
Team Charter
Where can I find the team charter template shown on the attached screenshot?

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