department

Ask a Question

Reporting on who and how many times an individual has attended eventsAnswered Question

Answered Melissa P-B 42 views 19 comments 0 points Most recent by Paul Newcome 03/27/20Formulas and Functions

First post 03/12/20,Last post 03/27/20
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all…
Formulas and Functions4219
Melissa P-B
Automatic Duration calculation from 2 Predecessory

Tibor Staub 16 views 7 comments 0 points Most recent by Paul Newcome 03/27/20Using Smartsheet

First post 03/27/20,Last post 03/27/20
Hello I have a Task B that cannot start before Task A was finished and that should finish the same time as Task C. When I enter 2 predecessors for B, namely that Task A has FS and Task C has FF, the smartsheet always takes into account o…
Using Smartsheet167
Tibor Staub
New Template Sets for these Workflow Categories! Let me know your thoughts!

Hunter Reed 14 views 0 comments 0 points Started by Hunter Reed 03/26/20 The New Work/Life Reality

First post 03/26/20,Last post 03/26/20
Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your orga…
The New Work/Life Reality140
Hunter Reed
Counting people with the same email domain in a multiselect assigned to cellAnswered Question

Answered Martina Barnett 20 views 7 comments 0 points Most recent by Paul Newcome 03/26/20Formulas and Functions

First post 03/25/20,Last post 03/26/20
Hi there I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual. I want to count how many of t…
Formulas and Functions207
Martina Barnett
How are you using Smartsheet to help you homeschool during COVID-19 closures?

Dana Esquivel 2.6K views 12 comments 9 points Most recent by Eric Demmitt 03/26/20The New Work/Life Reality

First post 03/17/20,Last post 03/26/20
We've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times p…
The New Work/Life Reality260212
Dana Esquivel
Managing and Reporting on Multiple Projects EffectivelyAnswered Question

Answered Rob Ford 44 views 1 comment 0 points Most recent by Debbie Sawyer 03/25/20Using Smartsheet

First post 03/23/20,Last post 03/25/20
I apologize for the length of my post, but I want to be thorough in describing what I would like to do and what I’ve already tried. I’ve also searched through help and the forums, and I either haven’t found a solution or am too hyperfocuse…
Using Smartsheet441
Rob Ford
Chart budget vs actualAnswered Question

Answered Laura Corredor 13 views 2 comments 0 points Most recent by Laura Corredor 03/25/20Using Smartsheet

First post 03/25/20,Last post 03/25/20
Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on. All I want to is to create a line-type chart for my d…
Using Smartsheet132
Laura Corredor
Automatic report creation with custom templateAnswered Question

Answered Jefferson Ribeiro 20 views 2 comments 0 points Most recent by Jefferson Ribeiro 03/25/20Using Smartsheet

First post 03/25/20,Last post 03/25/20
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. https://us.v-cdn.net/6031209/uploads/781/KSSZYBE6N9EB.png https://us.v-cdn.net/6031209/uploads/547/MXTN397LY9XS.png For each new answer on the form…
Using Smartsheet202
Jefferson Ribeiro
ODBC data pulls US date to mail mergeAccepted Answer

Accepted Answer PeterR 15 views 1 comment 0 points Most recent by Nathan Lloyd 03/25/20Using Smartsheet

First post 03/23/20,Last post 03/25/20
I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as date columns are switched from UK format…
Using Smartsheet151
PeterR
Link Data in a Smartsheet on a Specific Day and Make StaticAnswered Question

Answered Donna T 8 views 2 comments 0 points Most recent by Donna T 03/25/20Formulas and Functions

First post 03/25/20,Last post 03/25/20
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links dat…
Formulas and Functions82
Donna T
Is there a way to deal with "maybe situations" or varying predecessors?Answered Question

Answered Zoe Charalambous 25 views 1 comment 0 points Most recent by Alejandra 03/24/20Using Smartsheet

First post 03/19/20,Last post 03/24/20
Hi SmartSheet community! This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but o…
Using Smartsheet251
Zoe Charalambous
How do you expand the height of a row?Answered Question

Answered Danny Sax 16 views 3 comments 0 points Most recent by Andrée Starå 03/24/20Using Smartsheet

First post 03/23/20,Last post 03/24/20
How do you expand the height of a row?
Using Smartsheet163
Danny Sax
Create a work reportAnswered Question

Answered Ben Smith 20 views 3 comments 0 points Most recent by Paul Newcome 03/23/20Using Smartsheet

First post 03/23/20,Last post 03/23/20
I have a Gantt of a project which has weekly minutes compiled of site meetings and others. How do I create a specific report that goes to the project manager and asks him to load specific copy onto smartsheet?
Using Smartsheet203
Ben Smith
HELP with a large sheet and table layout/conditional formattingAnswered Question

Answered Melisa Dannhauser 32 views 2 comments 0 points Most recent by Melisa Dannhauser 03/23/20Using Smartsheet

First post 03/20/20,Last post 03/23/20
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each has 31 activities. Each activity has 3 d…
Using Smartsheet322
Melisa Dannhauser
Hidden Columns in Reports - edit, print, send dialoguesAccepted Answer

Accepted Answer DJB 13 views 3 comments 0 points Most recent by Andrée Starå 03/21/20Using Smartsheet

First post 03/21/20,Last post 03/21/20
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxe…
Using Smartsheet133
DJB
Which formula should I use if I want to add up all values from a column?Answered Question

Answered Jennifer Molina 13 views 1 comment 0 points Most recent by Andrée Starå 03/21/20Formulas and Functions

First post 03/21/20,Last post 03/21/20
To give a little bit of context, I am creating a report where I can count whether a cell has been filled with information. The column I am using is a drop down list with 5 values. Let's say these values are apples, bananas, oranges, pears,…
Formulas and Functions131
Jennifer Molina
At Risk Formula Unparseable ErrorAccepted Answer

Accepted Answer Kayla Johnstone 21 views 5 comments 0 points Most recent by Paul Newcome 03/20/20Using Smartsheet

First post 03/19/20,Last post 03/20/20
I am trying to build a nested at risk formula based on the following triggers. -End date is today and Status is not complete it will trigger -There is not enough time between today and the end date for the duration period left. So, if dura…
Using Smartsheet215
Kayla Johnstone
Aggregate Summary Field Data from Multiple SheetsAnswered Question

Answered TRMakai 38 views 1 comment 0 points Most recent by Sean Morgan 03/20/20Using Smartsheet

First post 03/12/20,Last post 03/20/20
I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management. See word doc for details https://us.v-cdn.net/6031209/uploads/305/8Y65LUXQQ3QC.docx Any sugges…
Using Smartsheet381
TRMakai
Auto send a completed form to an email addressAccepted Answer

Accepted Answer Ramone Palmer 29 views 12 comments 0 points Most recent by Paul Newcome 03/17/20Using Smartsheet

First post 03/17/20,Last post 03/17/20
Hi, I am fairly new to Smartsheet, and was able to create a sheet and a linked form to replace our old HR blast process. My question is this, I created a form, and we have a list of users who needs to get an update/notified of all fields…
Using Smartsheet2912
Ramone Palmer
Automation Suddenly Not WorkingAnswered Question

Answered Alejandra Orihuela 14 views 5 comments 0 points Most recent by Alejandra Orihuela 03/17/20Using Smartsheet

First post 03/17/20,Last post 03/17/20
I have an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else having automation problems??
Using Smartsheet145
Alejandra Orihuela
Custom Domain?Answered Question

Answered Steve C 26 views 1 comment 0 points Most recent by Andrée Starå 03/15/20Using Smartsheet

First post 03/14/20,Last post 03/15/20
Hi there, I am an enterprise user with Smartsheet. I would like to setup a custom domain for my clients to access their Smartsheet view. For example: portal.mydomain.com They will be able to login using their custom credentials and acce…
Using Smartsheet261
Steve C
Is there a way to auto-hide columns based on the value selected from a drop down cell?Answered Question

Answered Nikki Hopper 18 views 1 comment 0 points Most recent by Andrée Starå 03/12/20Using Smartsheet

First post 03/12/20,Last post 03/12/20
I have a main grid with several columns and a webform that feeds into that grid. This tracker is used by my team to track several job "types" defined in one of the destination grid columns as "Large Project", Medium Pro…
Using Smartsheet181
Nikki Hopper
Test logAnswered Question

Answered Stanley Paul 23 views 4 comments 0 points Most recent by Michele Thomas 03/12/20Using Smartsheet

First post 03/09/20,Last post 03/12/20
Can someone provide some insight to creating a testing log? Either point me to an existing Smartsheet template set that can be massaged to fit my testing needs or have a test log template set that you are willing to share.
Using Smartsheet234
Stanley Paul
Counting completion status off of a group of sheetsAnswered Question

Answered Mike Wilday 16 views 3 comments 0 points Most recent by Genevieve P 03/12/20Formulas and Functions

First post 03/11/20,Last post 03/12/20
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am tryin…
Formulas and Functions163
Mike Wilday
Color Coding for Names / Owners onlyAccepted Answer

Accepted Answer Jena Heath 13 views 1 comment 0 points Most recent by Paul Newcome 03/10/20Formulas and Functions

First post 03/10/20,Last post 03/10/20
I'm trying to find out if I can color code only the name bubble. For example, below I'm using the multiple-drop down column formatting and all names are shown in grey. It would be nice to show Whitney in purple, and Laura in yellow, so th…
Formulas and Functions131
Jena Heath
count tasks per week numberAnswered Question

Answered Assaf Elad 22 views 1 comment 0 points Most recent by Paul Newcome 03/10/20Formulas and Functions

First post 03/10/20,Last post 03/10/20
Hi community, I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year. Here is my formula that calculate 0 every time (at least not an error) : =COU…
Formulas and Functions221
Assaf Elad
Nested if for RYG Balls and qty not workingAccepted Answer

Accepted Answer Marina Dixon 38 views 5 comments 0 points Most recent by Paul Newcome 03/09/20Formulas and Functions

First post 03/03/20,Last post 03/09/20
I am trying to use the RYG balls when noting when a variance has gone over certain amounts: 5000 or less - Green 5000-10000 - Yellow over 10000 - Red I can add grey as my false statement if the coordinator has checked off the completed box…
Formulas and Functions385
Marina Dixon
Jira Plug-in IT Support

kimberlee.adam89166 33 views 2 comments 0 points Most recent by Elie Abouzeid 03/08/20Using Smartsheet

First post 01/30/20,Last post 03/08/20
How do I get someone from Smartsheet IT support to contact me? I received a trial version of the Jira plug-in but having issues get it connected and have been trying to contact support for 2 weeks now. I've created a support ticket, emaile…
Using Smartsheet332
kimberlee.adam89166
Can i remove multi-select from single cell?Answered Question

Answered System JDT 19 views 1 comment 0 points Most recent by jpagan03101416 03/06/20Formulas and Functions

First post 03/06/20,Last post 03/06/20
Hi folks, Bit of a novice here, i have a challenge for you 😁 We use smartsheet for tracking holiday, sick leave, unpaid leave etc. For 2019/20 we've only had a single-select option for each cell, but this makes it difficult to track when…
Formulas and Functions191
System JDT
Create formula to count category risk with aggregate ratingAnswered Question

Answered Jorjie Higginson 25 views 3 comments 0 points Most recent by JReisman27 03/05/20Formulas and Functions

First post 03/05/20,Last post 03/05/20
Hi, I have a risk register for a project that has well over 100 risks documented and I have them categorized into 17 different risks. I would like to be able to create a formula to count how many risks exist under each category and then a…
Formulas and Functions253
Jorjie Higginson

Ask a Question

department

department

Discussion List