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
    49 2
    Accepted Answer 49 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
    33 3
    Accepted Answer 33 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
    161 4
    Answered - Pending Review 161 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
    259 7
    Answered - Pending Review 259 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
    187 3
    Accepted Answer 187 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
    16 1
    Answered - Pending Review 16 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). Currently, I go into my powerpoint file, click File, and then Share -> Embed and copy/paste the …
    Answered - Pending Review
    518 1
    Answered - Pending Review 518 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
    43 7
    Answered - Pending Review 43 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
    54 3
    Accepted Answer 54 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
    172 3
    Answered - Pending Review 172 views 3 comments Most recent by djpreece Using Smartsheet