Smartsheet Basics

Archives for May 2020

Building a workflow to trigger on a comparison of two columns
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?
Sum formula not working
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, [Interim Reviews]7)) Thanks
Sheet Linking - Project sheets to single metrics sheet
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 analysed. The information & metrics from all projects should be collected in the Metrics sheet.…
Count Up Timer
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 are currently Hrs:Min:Sec able to show for about 48 hours. I tried importing a few timers but…
Automation based on Sheet Summary
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 separate summary sheet to track approvals, etc) has been fairly clunky for our team so I'm…
I just deleted Columns in a Smartsheet and I have no backup
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!
Can't embed powerpoint into Smartsheets dashboard
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 iframes code. I have also tried Share with People and copy/pasting that link into the URL…
Turn off "others are now viewing this sheet"
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 normal Smartsheet and reports/dynamic views/etc are not options for the type of workflow…
Project Rollup
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 links to all those individual client project sheets. I included a report on the bottom of…
Setting different working days for individuals
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 - is this possible? Any advice would be gratefully received. Thanks

Trending in Smartsheet Basics

Alerts
Hi there, I want to use the trigger and alert to notify someone in the next row when the task above is complete. E.g., if the Status column is changed to Complete in row 3, I want an alert to be sent to the contact in the Assigned To column in row 4. Is that possible? Megan
MAX COLLECT for dates in a row
I have a certification that requires a few lessons to be fully certified. Each lesson has a completion date in it's own column and a date column for when they become fully certified. So, if there if one training is missing a completion date they are not considered fully certified. My need is to be able to collect the max…
PDF Icon / Thumbnail in the row?
Hi, I'm sure its a big use of smart sheet, I use various registers to store documents especially drawings. Each row is a drawing or document, if there are different Issues I use the upload new version. There are the Ref#, Issue#, description and drawn date columns etc. The drawing is a pdf attachment. However you can not…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List