Using Smartsheet

Webinar recording available: Top 5 tips for optimizing your sheets

Announcement Anna Mkrtchyan 176 views 2 comments 0 points Most recent by Paul Newcome 05/08/20

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
How do we improve formatting such as merged cells?

beatea 34 views 4 comments 0 points Most recent by James Watt 05/31/20

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
Building a workflow to trigger on a comparison of two columnsQuestion

Question Chuck Homola 5 views 0 comments 0 points Started by Chuck Homola 05/31/20

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
Sum formula not workingQuestion

Question Jeana 4 views 0 comments 0 points Started by Jeana 05/30/20

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
Can I use @row in this formula?Accepted Answer

Accepted Answer Jason Wirl 27 views 12 comments 0 points Most recent by Jason Wirl 05/30/20

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
Sheet Linking - Project sheets to single metrics sheetQuestion

Question Abhiraj Joshi 6 views 0 comments 0 points Started by Abhiraj Joshi 05/30/20

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
Count Up TimerQuestion

Question Jaison Scott 6 views 0 comments 0 points Started by Jaison Scott 05/29/20

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
I just deleted Columns in a Smartsheet and I have no backupQuestion

Answered - Pending Review Sandy Challman 12 views 1 comment 0 points Most recent by Andrée Starå 05/29/20

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
Publishing and Google Search indexing and crawlingAccepted Answer

Accepted Answer Mary_A 69 views 7 comments 0 points Most recent by Mary_A 05/29/20

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
Automation based on Sheet SummaryQuestion

Answered - Pending Review Jessy Martin 9 views 1 comment 0 points Most recent by Andrée Starå 05/29/20

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
Auto fill a cell when a new row is addedQuestion

Answered - Pending Review jeflanne 20 views 2 comments 0 points Most recent by cfavron103911 05/29/20

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
Need a formula to count how many of each Support Type is assigned to each Assignee.Question

Answered - Pending Review Ashley Pierce 16 views 4 comments 0 points Most recent by Ashley Pierce 05/29/20

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
Any templates or sample of multiple project dashboards?

Fairorth 329 views 10 comments 0 points Most recent by Martha Brown 05/29/20

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
Project RollupQuestion

Answered - Pending Review susannebankhead 17 views 2 comments 0 points Most recent by susannebankhead 05/29/20

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
Conditional Formatting in a Report

Melissa Wells 469 views 5 comments 0 points Most recent by Chris Rea 05/29/20

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
How do I set SmartSheet to include attachments on the emails that it sends from automation?Accepted Answer

Accepted Answer Felicia Wilson 266 views 16 comments 0 points Most recent by Sean Bernardino 05/29/20

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
Turn off "others are now viewing this sheet"Question

Answered - Pending Review Michael Heisler 13 views 2 comments 0 points Most recent by Michael Heisler 05/29/20

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
Can't embed powerpoint into Smartsheets dashboardQuestion

Question Jean Ye 14 views 0 comments 0 points Started by Jean Ye 05/29/20

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
Automated workflow logQuestion

Answered - Pending Review Mikecol 50 views 4 comments 1 point Most recent by Werner Gerstacker 05/29/20

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
Master work-flows in JIRA?Question

Answered - Pending Review Henry Kenton 12 views 2 comments 0 points Most recent by Henry Kenton 05/29/20

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
Issue with Progress calculation of weighted valuesQuestion

Answered - Pending Review Wendy Young 31 views 3 comments 0 points Most recent by Wendy Young 05/29/20

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
Setting different working days for individualsQuestion

Question Harriet Blackborow 9 views 0 comments 0 points Started by Harriet Blackborow 05/29/20

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
Automations not sending out reminders to all contacts

Emma Smyth 7 views 0 comments 0 points Started by Emma Smyth 05/29/20

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
COUNTIFS NON Blank QuestionQuestion

Answered - Pending Review Joel Brumback 16 views 3 comments 0 points Most recent by Paul Newcome 05/29/20

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
Limit View to a user for one filter OnlyAccepted Answer

Accepted Answer Julie Barbeau 34 views 5 comments 0 points Most recent by Julie Barbeau 05/29/20

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
Weekly tasks automation on task managementAccepted Answer

Accepted Answer Natasha Szczerb 15 views 3 comments 0 points Most recent by Andrée Starå 05/29/20

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
The 'Send' and "Send Update Request...' functions are not working for our licensed users.Question

Answered - Pending Review lisa.hollister84496 12 views 3 comments 0 points Most recent by Andrée Starå 05/29/20

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
Creating Headers for your Smartsheet

mallen65961 1.4K views 4 comments 0 points Most recent by omatikainen 05/29/20

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
Formula to calculate tasks based on % completeQuestion

Answered - Pending Review Vanessa Campos 13 views 1 comment 0 points Most recent by Andrée Starå 05/29/20

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
Count if offQuestion

Answered - Pending Review Scott Peloquin 8 views 1 comment 0 points Most recent by Mike Wilday 05/29/20

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
List of date formula I have used repeatedly

[email protected] 35 views 6 comments 0 points Most recent by [email protected] 05/28/20

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]

Using Smartsheet

Using Smartsheet

Discussion List