Using Smartsheet

Archives for May 2020

Discussion List

  • Building a workflow to trigger on a comparison of two columns
    In Using Smartsheet
    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?
    Accepted
    15 2
    Accepted Answer 15 views 2 comments Most recent by Chuck Homola Using Smartsheet
  • Sum formula not working
    In Using Smartsheet
    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…
    Accepted
    21 3
    Accepted Answer 21 views 3 comments Most recent by Genevieve P Using Smartsheet
  • Sheet Linking - Project sheets to single metrics sheet
    In Using Smartsheet
    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…
    Answered - Pending Review
    56 4
    Answered - Pending Review 56 views 4 comments Most recent by Abhiraj Joshi Using Smartsheet
  • Count Up Timer
    In Using Smartsheet
    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…
    Answered - Pending Review
    76 7
    Answered - Pending Review 76 views 7 comments Most recent by Paul Newcome Using Smartsheet
  • Automation based on Sheet Summary
    In Using Smartsheet
    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…
    Accepted
    23 3
    Accepted Answer 23 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • I just deleted Columns in a Smartsheet and I have no backup
    In Using Smartsheet
    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!
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Can't embed powerpoint into Smartsheets dashboard
    In Using Smartsheet
    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). (Image) Currently, I go into my powerpoint file, click File, and then Share -> Embed and copy/pa…
    Answered - Pending Review
    78 1
    Answered - Pending Review 78 views 1 comment Most recent by Genevieve P Using Smartsheet
  • Turn off "others are now viewing this sheet"
    In Using Smartsheet
    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…
    Answered - Pending Review
    32 7
    Answered - Pending Review 32 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Project Rollup
    In Using Smartsheet
    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…
    Accepted
    41 3
    Accepted Answer 41 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • Setting different working days for individuals
    In Using Smartsheet
    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 -…
    Answered - Pending Review
    23 2
    Answered - Pending Review 23 views 2 comments Most recent by Harriet Blackborow Using Smartsheet