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 Functions42Melissa P-B
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 Smartsheet16Tibor Staub
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 Reality14Hunter Reed
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 Functions20Martina Barnett
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 Reality2602Dana Esquivel
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 Smartsheet44Rob Ford
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 Smartsheet13Laura Corredor
I am working on creating a report in which data is obtained using a Smartsheet form.
For each new answer on the form…
Using Smartsheet20Jefferson Ribeiro
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…
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 Functions8Donna T
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 Smartsheet25Zoe Charalambous
How do you expand the height of a row?
Using Smartsheet16Danny Sax
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 Smartsheet20Ben Smith
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 Smartsheet32Melisa Dannhauser
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…
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 Functions13Jennifer Molina
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 Smartsheet21Kayla Johnstone
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
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 Smartsheet29Ramone Palmer
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 Smartsheet14Alejandra Orihuela
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 Smartsheet26Steve C
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 Smartsheet18Nikki Hopper
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 Smartsheet23Stanley Paul
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 Functions16Mike Wilday
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 Functions13Jena Heath
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) :
Formulas and Functions22Assaf Elad
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 Functions38Marina Dixon
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…
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 Functions19System JDT
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 Functions25Jorjie Higginson