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? =VA…
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) wh…
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 tim…
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 st…
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!
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 …
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…
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 dashbo…
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 refl…
I am using Symbols in my sheet for 'risk level' using the standard Red, Yellow & Green. I then have a report showing how many/what percentage of risk we have per risk status above. I have added the re…
i'm using the project tracking and rollup template set and trying to add all of the members of my team to the pulldown for 'assigned to'. i cannot seem to add more than 6 members, or the list automati…
I have a very simple sheet that has a column of numbers. Using a Sheet Summary formula such as =sum([column1]:[column1]) I get an answer, but it loses the number formatting - specifically the thousand…
