Using Smartsheet

Using Smartsheet

 

Discussion List

  • Anna Mkrtchyan
    Announcement Anna Mkrtchyan 176 views 2 comments Most recent by Paul Newcome
    First post 04/30/20,Last post 05/08/20
    Missed the webinar? Review the recording in the Smartsheet Learning Center. Top 5 tips for optimizing your sheets. Learn best practices for getting the most out of your Smartsheet, including sheet structure, collaborating in a variety of w…
    Using Smartsheet1762
    Anna Mkrtchyan
  • beatea
    beatea 34 views 4 comments Most recent by James Watt
    First post 09/12/19,Last post 05/31/20
    What other options do we have to format the sheet better, perhaps even in sections? Merging some cells will help get rid of the lines and make things look better spacing wise.
    Using Smartsheet344
    beatea
  • Chuck Homola
    Question Chuck Homola 5 views 0 comments Started by Chuck Homola
    First post 05/31/20,Last post 05/31/20
    I am building a workflow where I want to trigger an alert when the value in one column is less then the value in another column. How do I do that?
    Using Smartsheet50
    Chuck Homola
  • Jeana
    Question Jeana 4 views 0 comments Started by Jeana
    First post 05/30/20,Last post 05/30/20
    Trying to sum cells in a row that have value based on a formula. I've read that this can be an issue and to use VALUE in the equation. However, I'm still getting a RED Zero as a result. Any ideas? =VALUE(SUM([Printing and Shipping]7, [Int…
    Using Smartsheet40
    Jeana
  • Jason Wirl
    Accepted Answer Jason Wirl 27 views 12 comments Most recent by Jason Wirl
    First post 05/08/20,Last post 05/30/20
    =IFERROR(COUNTIFS([Expected Close Date]:[Expected Close Date], YEAR(@cell) = 2020, [Sales Stage]:[Sales Stage], "A"), "Check for 'Blanks' in Forecast, Probability or Close Date") =IFERROR(COUNTIFS([Expected Close Date…
    Using Smartsheet2712
    Jason Wirl
  • Abhiraj Joshi
    Question Abhiraj Joshi 6 views 0 comments Started by Abhiraj Joshi
    First post 05/30/20,Last post 05/30/20
    Hi, I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and ana…
    Using Smartsheet60
    Abhiraj Joshi
  • Jaison Scott
    Count Up TimerQuestion
    Question Jaison Scott 6 views 0 comments Started by Jaison Scott
    First post 05/29/20,Last post 05/29/20
    Hey all. Brand new (3 days) Smart Sheet user. I am working on an exercise with my team and would like to have a running "count up" timer (stop watch if you will) in a dashboard that shows from the time we kicked off to where we a…
    Using Smartsheet60
    Jaison Scott
  • Sandy Challman
    Answered - Pending Review Sandy Challman 12 views 1 comment Most recent by Andrée Starå
    First post 05/29/20,Last post 05/29/20
    I thought I was in a Report. BUT I was in a filter and I deleted several columns from a sheet. I do not have a backup. In the recent history it will not show the data in the columns either. HELP!
    Using Smartsheet121
    Sandy Challman
  • Mary_A
    Accepted Answer Mary_A 69 views 7 comments Most recent by Mary_A
    First post 02/11/20,Last post 05/29/20
    Business and Enterprise users can publish a sheet, report, or dashboard. My question is can these pages be discovered by Google Search indexing and crawling? These are the options I refer to: https://us.v-cdn.net/6031209/uploads/838/W1JO7W…
    Using Smartsheet697
    Mary_A
  • Jessy Martin
    Answered - Pending Review Jessy Martin 9 views 1 comment Most recent by Andrée Starå
    First post 05/29/20,Last post 05/29/20
    Can I set up an automation based on a field in a sheet summary? What I'm ultimately trying to do is set up a review/approval workflow for an entire spreadsheet. Everything I've tried so far (adding status column to the sheet, using a sepa…
    Using Smartsheet91
    Jessy Martin
  • jeflanne
    Answered - Pending Review jeflanne 20 views 2 comments Most recent by cfavron103911
    First post 05/26/20,Last post 05/29/20
    How do I auto populate a column when a new row is added?
    Using Smartsheet202
    jeflanne
  • Ashley Pierce
    Answered - Pending Review Ashley Pierce 16 views 4 comments Most recent by Ashley Pierce
    First post 05/29/20,Last post 05/29/20
    https://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 Smartsheet164
    Ashley Pierce
  • Fairorth
    Fairorth 329 views 10 comments Most recent by Martha Brown
    First post 12/06/19,Last post 05/29/20
    Our 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 Smartsheet32910
    Fairorth
  • susannebankhead
    Project RollupQuestion
    Answered - Pending Review susannebankhead 17 views 2 comments Most recent by susannebankhead
    First post 05/29/20,Last post 05/29/20
    We'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 Smartsheet172
    susannebankhead
  • Melissa Wells
    Melissa Wells 469 views 5 comments Most recent by Chris Rea
    First post 09/10/18,Last post 05/29/20
    Is 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 Smartsheet4695
    Melissa Wells
  • Felicia Wilson
    Accepted Answer Felicia Wilson 266 views 16 comments Most recent by Sean Bernardino
    First post 01/29/20,Last post 05/29/20
    Has 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 Smartsheet26616
    Felicia Wilson
  • Michael Heisler
    Answered - Pending Review Michael Heisler 13 views 2 comments Most recent by Michael Heisler
    First post 05/29/20,Last post 05/29/20
    Hello, 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 Smartsheet132
    Michael Heisler
  • Jean Ye
    Question Jean Ye 14 views 0 comments Started by Jean Ye
    First post 05/29/20,Last post 05/29/20
    Hi 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 Smartsheet140
    Jean Ye
  • Mikecol
    Answered - Pending Review Mikecol 50 views 4 comments Most recent by Werner Gerstacker
    First post 02/28/20,Last post 05/29/20
    Hello, 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 Smartsheet504
    Mikecol
  • Henry Kenton
    Answered - Pending Review Henry Kenton 12 views 2 comments Most recent by Henry Kenton
    First post 05/28/20,Last post 05/29/20
    From 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 Smartsheet122
    Henry Kenton
  • Wendy Young
    Answered - Pending Review Wendy Young 31 views 3 comments Most recent by Wendy Young
    First post 05/20/20,Last post 05/29/20
    Good 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 Smartsheet313
    Wendy Young
  • Harriet Blackborow
    Question Harriet Blackborow 9 views 0 comments Started by Harriet Blackborow
    First post 05/29/20,Last post 05/29/20
    Is 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 Smartsheet90
    Harriet Blackborow
  • Emma Smyth
    Emma Smyth 7 views 0 comments Started by Emma Smyth
    First post 05/29/20,Last post 05/29/20
    Hello 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 Smartsheet70
    Emma Smyth
  • Joel Brumback
    Answered - Pending Review Joel Brumback 16 views 3 comments Most recent by Paul Newcome
    First post 05/29/20,Last post 05/29/20
    I 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 Smartsheet163
    Joel Brumback
  • Julie Barbeau
    Accepted Answer Julie Barbeau 34 views 5 comments Most recent by Julie Barbeau
    First post 05/05/20,Last post 05/29/20
    Hi, 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 Smartsheet345
    Julie Barbeau
  • Natasha Szczerb
    Accepted Answer Natasha Szczerb 15 views 3 comments Most recent by Andrée Starå
    First post 05/28/20,Last post 05/29/20
    Hello, 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 Smartsheet153
    Natasha Szczerb
  • lisa.hollister84496
    Answered - Pending Review lisa.hollister84496 12 views 3 comments Most recent by Andrée Starå
    First post 05/29/20,Last post 05/29/20
    Did something change? We rely quite heavily on these functions. Any insight would be appreciated. Thank you very much! https://us.v-cdn.net/6031209/uploads/J4UK5UVOM7VT/ss-notifications-jpg.jpg
    Using Smartsheet123
    lisa.hollister84496
  • mallen65961
    mallen65961 1.4K views 4 comments Most recent by omatikainen
    First post 08/22/19,Last post 05/29/20
    I would like to know how to create a header for my Smartsheet.
    Using Smartsheet13694
    mallen65961
  • Vanessa Campos
    Answered - Pending Review Vanessa Campos 13 views 1 comment Most recent by Andrée Starå
    First post 05/29/20,Last post 05/29/20
    I have a list of deliverables with a % complete column and I want to calculate the total number of: completed (at 100%) in progress (between 1% and 99%) not started (0%) I am using the following formula for completed and it is giving …
    Using Smartsheet131
    Vanessa Campos
  • Scott Peloquin
    Count if offQuestion
    Answered - Pending Review Scott Peloquin 8 views 1 comment Most recent by Mike Wilday
    First post 05/28/20,Last post 05/29/20
    I am trying to use a simple formula to count my number of different colored symbols in a column, RYG. I have many parent rows with 6 children each. 14 of the parent rows have a green symbol and all the others are currently blank, no symb…
    Using Smartsheet81
    Scott Peloquin
  • L@123
    [email protected] 35 views 6 comments Most recent by [email protected]
    First post 05/20/20,Last post 05/28/20
    Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most basic of the formulas out of this. Bel…
    Using Smartsheet356
    [email protected]