Recent Discussions
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Answered - Pending Review Ashley Pierce 16 views 4 comments 0 points Most recent by Ashley Pierce Using SmartsheetFirst post 05/29/20,Last post 05/29/20https://us.v-cdn.net/6031209/uploads/ZDY6TLKNMPHW/annotation-17.png For example, for the DFM/DDFM Support Type, I would like to know that there are: Communication: (1) Ashley Pierce (1) Tanner May Proposal Review: (1) Alexa Briggs (2) Ashl…Using Smartsheet164Ashley Pierce
-
First post 12/06/19,Last post 05/29/20Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project. Most of the reports and dashboards I've tried to crea…Using Smartsheet32910Fairorth -
Project RollupQuestionAnswered - Pending Review susannebankhead 17 views 2 comments 0 points Most recent by susannebankhead Using SmartsheetFirst post 05/29/20,Last post 05/29/20We're a small communications/creative agency using Smartsheet for project management for all our client work. Each client has a sheet created for projects, deadlines, team assignments. I have a dashboard created as a landing page with link…Using Smartsheet172susannebankhead
-
Stacked Bar GraphQuestionAnswered - Pending Review katebrew 9 views 3 comments 0 points Most recent by Werner Gerstacker Formulas and FunctionsFirst post 05/29/20,Last post 05/29/20I am trying to create a stacked bar graph using data from a sheet summary report however I have not get the report data to pull into rows as I select the field to be added to the report they are popluated as columns only.Formulas and Functions93katebrew
-
First post 05/28/20,Last post 05/29/20I would like to have the parent row of my health column automatically be red, green or yellow based on the average health of it's child rows. Does anyone have an idea of how to accomplish this?Formulas and Functions102Cara Sikes
-
Accepted Answer Jeana 18 views 5 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/28/20,Last post 05/29/20I want to populate a name(s) in a Contact list based on the value of another field. For example: If a cell contains "Copyediting" I want Holly's name to be added to Additional Assets (a contact list). Thanks, JeanaFormulas and Functions185Jeana
-
First post 09/10/18,Last post 05/29/20Is it possible to include Conditional Formatting in a Report? I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports. Thanks!Using Smartsheet4695Melissa Wells -
Help with IF(INDEX(MATCHAccepted AnswerAccepted Answer Zach Johnson 36 views 25 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 04/30/20,Last post 05/29/20Hi all, First question in the forum. I'm in need of help with an INDEX(MATCH( formula that I've been using but now need to make conditional on another column. Essentially, I only want the INDEX(MATCH( formula to return a value when a col…Formulas and Functions3625Zach Johnson
-
How do I set SmartSheet to include attachments on the emails that it sends from automation?Accepted AnswerAccepted Answer Felicia Wilson 266 views 16 comments 0 points Most recent by Sean Bernardino Using SmartsheetFirst post 01/29/20,Last post 05/29/20Has anyone had success in having SmartSheet include attachments on the emails that it sends from workflow you set up? When I create a workflow in SmartSheet to send an alert to someone I want to have the email the user gets include an at…Using Smartsheet26616Felicia Wilson
-
Answered - Pending Review Michael Heisler 13 views 2 comments 0 points Most recent by Michael Heisler Using SmartsheetFirst post 05/29/20,Last post 05/29/20Hello, is there a way to turn off this notification or any idea what can be causing this, there were only about 8 people in this at one time? (see below) It ends up taking over the screen and makes it difficult to work. This is just a no…Using Smartsheet132Michael Heisler
-
Answered - Pending Review Grace Hurt 43 views 2 comments 0 points Most recent by Jared Davis Formulas and FunctionsFirst post 05/01/20,Last post 05/29/20Hi all, With the new update to Smartsheet forms, we are able to add conditional logic to designated fields within a form. However, I noticed that while you can set logic to only populate designated fields when a certain option is selected,…Formulas and Functions432Grace Hurt
-
First post 05/29/20,Last post 05/29/20Hi all, I'm having trouble embedding a powerpoint file in my Dashboard. Whenever I add the link, I get an error message (photo attached). https://us.v-cdn.net/6031209/uploads/X9CC78TID6RB/smartsheets-error-png.png Currently, I go into my…Using Smartsheet140Jean Ye
-
Answered - Pending Review Amy Balich 19 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/29/20,Last post 05/29/20https://us.v-cdn.net/6031209/uploads/DBVW41DJLDCN/snip-png.png I am trying to add together the total quantity made on a certain date and time. For example, in the screenshot, I have two rows that contain 5/18/20 that occur on floorhour 5. …Formulas and Functions193Amy Balich -
Answered - Pending Review Jörg Schmidt Novum Hospitality 10 views 1 comment 0 points Most recent by Werner Gerstacker Formulas and FunctionsFirst post 05/29/20,Last post 05/29/20Hi, what could be the Formula in @cell "b" to insert the email address of a person whose name is written in cell "a" ?Formulas and Functions101Jörg Schmidt Novum Hospitality
-
Answered - Pending Review Lng98881 7 views 1 comment 0 points Most recent by Werner Gerstacker Formulas and FunctionsFirst post 05/29/20,Last post 05/29/20Hello, I have a Smartsheet where I'm trying to count distinct values in a column. Currently I've tried this but get #UNPARSEABLE. =Count(Distinct(Collect(Prj_ID:Prj_ID,Prj_ID:Prj_ID,[email protected]))) Where Prj_ID is the column where I want to…Formulas and Functions71Lng98881
-
Automated workflow logQuestionAnswered - Pending Review Mikecol 50 views 4 comments 1 point Most recent by Werner Gerstacker Using SmartsheetFirst post 02/28/20,Last post 05/29/20Hello, Is there a way to see a when an automated workflow is triggered in smartsheet? Specifically around the time sent and who the recipients were. When I check the activity log, I can only see when a automated workflow has changed. The…Using Smartsheet504Mikecol
-
Accepted Answer Jonathan LeBlanc 12 views 3 comments 0 points Most recent by Jonathan LeBlanc Formulas and FunctionsFirst post 05/28/20,Last post 05/29/20I have 2 columns: first column is a multi-select with multiple, the second column are all dates. I want to pull the latest date by each of the items available in the multi-select I figure its some combination of If, Large, and contains. bu…Formulas and Functions123Jonathan LeBlanc
-
First post 05/28/20,Last post 05/29/20I would like to have the parent row of my health column automatically be red, green or yellow based on the average health of it's child rows. Does anyone have an idea of how to accomplish this?Formulas and Functions101Cara Sikes
-
First post 11/19/18,Last post 05/29/20I'd like to get a list of unique values in a range. I'm finding a lot on the community about how to flag duplicates, but not sure how to get a list where each unique value appears in a cell. Screenshot below is what I'm looking for. My goa…Formulas and Functions63616SYSPK -
Master work-flows in JIRA?QuestionAnswered - Pending Review Henry Kenton 12 views 2 comments 0 points Most recent by Henry Kenton Using SmartsheetFirst post 05/28/20,Last post 05/29/20From what I can make out, I can only have a 1:1 for work-flows and sheets, and not a master work-flow which can be repeatedly used across all new sheets created. Is a master work-flow possible?Using Smartsheet122Henry Kenton
-
Locking a line after a certain dateAccepted AnswerAccepted Answer Julie Barbeau 8 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/29/20,Last post 05/29/20Hi to all, Does he have a way of using a formula to make a line lock after a certain date? For example, in our timesheet, create a formula that says: lock this row if the date in the column ''Date'' is 7 days after today's date? ThanksFormulas and Functions81Julie Barbeau
-
Answered - Pending Review Wendy Young 31 views 3 comments 0 points Most recent by Wendy Young Using SmartsheetFirst post 05/20/20,Last post 05/29/20Good morning, I'm calculating the completion progress for a project with weighted values on individual tasks. However, it's only calculating 50% of the actual progress. This is the formula that I'm using: =AVGW(PROGRESS:PROGRESS, [WEIGHT…Using Smartsheet313Wendy Young
-
Question Harriet Blackborow 9 views 0 comments 0 points Started by Harriet Blackborow Using SmartsheetFirst post 05/29/20,Last post 05/29/20Is there a way to set different working days for individuals? I know that it is possible to define working days through the Project Settings function but I want to set this for one person only to reflect their part time working structure -…Using Smartsheet90Harriet Blackborow
-
Answered - Pending Review ICue 11 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/28/20,Last post 05/29/20I'm trying to figure out a formula to return the value in a cell over multiple columns. I have 10 locations consisting of various buildings for each location. Only one column will have text in it. The formula I have will obviously only re…Formulas and Functions113ICue
-
First post 05/29/20,Last post 05/29/20Hello We have multiple automations set that are working and we are receiving the reminders but for some reason for this specific automation we are not receiving the reminder. Is it because the row is being moved instantly? https://us.v-cdn…Using Smartsheet70Emma Smyth
-
Hunter Reed 558 views 5 comments 6 points Most recent by Sheila Castellanos The New Work/Life RealityFirst post 03/26/20,Last post 05/29/20Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your orga…The New Work/Life Reality5585Hunter Reed -
COUNTIFS NON Blank QuestionQuestionAnswered - Pending Review Joel Brumback 16 views 3 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/29/20,Last post 05/29/20I have two columns, "Assigned To" and "Date Entered". What I want is to count blank "Date Entered" cells that are assigned to a specific person. Is this possible?Using Smartsheet163Joel Brumback
-
Limit View to a user for one filter OnlyAccepted AnswerAccepted Answer Julie Barbeau 34 views 5 comments 0 points Most recent by Julie Barbeau Using SmartsheetFirst post 05/05/20,Last post 05/29/20Hi, I used a sheet to create a global timesheet for one department. Then I created one filter by employee so they can see only the row who applied to them. Is there a way to limit view by user? By example, I want that Marc see only the vie…Using Smartsheet345Julie Barbeau
-
Weekly tasks automation on task managementAccepted AnswerAccepted Answer Natasha Szczerb 15 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/28/20,Last post 05/29/20Hello, I'm optimising a task management sheet with automation and would like to know if there's a way to use automation to create a row? Some tasks are weekly, and it'd be great if they could be automatically added in every week, so the ow…Using Smartsheet153Natasha Szczerb
-
Answered - Pending Review Shelley Isbell 15 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/28/20,Last post 05/29/20Hi! I would like the status column to change corosponding to adding a date to the Started Working Proof Sent and Closed Date. I got it to work with the started working date, however I cant figure out how to add teh Proof Sent and Close…Formulas and Functions151Shelley Isbell
