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 Smartsheet176Anna Mkrtchyan
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.
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 Smartsheet5Chuck Homola
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.
=VALUE(SUM([Printing and Shipping]7, [Int…
=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 Smartsheet27Jason Wirl
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 Smartsheet6Abhiraj Joshi
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 Smartsheet6Jaison Scott
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 Smartsheet12Sandy Challman
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:
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 Smartsheet9Jessy Martin
How do I auto populate a column when a new row is added?
For example, for the DFM/DDFM Support Type, I would like to know that there are:
(1) Ashley Pierce
(1) Tanner May
(1) Alexa Briggs
Using Smartsheet16Ashley Pierce
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…
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…
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.
Using Smartsheet469Melissa Wells
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 Smartsheet266Felicia Wilson
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 Smartsheet13Michael Heisler
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…
Using Smartsheet14Jean Ye
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.
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 Smartsheet12Henry Kenton
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 Smartsheet31Wendy Young
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 Smartsheet9Harriet Blackborow
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?
Using Smartsheet7Emma Smyth
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 Smartsheet16Joel Brumback
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 Smartsheet34Julie Barbeau
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 Smartsheet15Natasha Szczerb
Did something change? We rely quite heavily on these functions.
Any insight would be appreciated.
Thank you very much!
I would like to know how to create a header for my Smartsheet.
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 Smartsheet13Vanessa Campos
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 Smartsheet8Scott Peloquin
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 Smartsheet35[email protected]