Hi all -- I am new. Trying to get a bubble chart template that I can use to make a gorgeous bubble chart. No results when I start a new sheet and type in "bubble chart."
Thanks very very much -- Andrea
My company has been using Smartsheet for the better part of 3 years now. Some staffers have had training but nothing too extensive. My company recently merged both the Communications and Marketing departments and I have been tasked wi…
API & Developers19Travis Pryor
Hello, I have a sheet that tracks donations as they are received; name, email, and amount of the donation. Some are one time donors, others are repeat donors, and I would like to create a summary page that lists each individual donor and …
Formulas and Functions23eshin35
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…
How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added?
Formulas and Functions33ddrame103286
Does anyone know if there's a way to limit form access to a specific person or group of people. Or, is there something in the works at Smartsheet to address this? Looks like there is currently two options.
* Anyone with a Smart…
1 Can I do conditional formating using more than one criteria (different Columns)
(Image) We track goals for residents and if the goal is not met within the required timeline I would like it to highlight the total in red.
is there a way to…
Formulas and Functions60Jason Christensen
I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing somethi…
Formulas and Functions144Samira
I was wondering if this is possible yet, or if there have been any updates?
Importing from Smartsheet into Outlook is nice, but I would love to have…
Using Smartsheet320Paul Newcome
I'm trying to add Q1 totals with the rest of the quarters of 2019. Here is the formula I'm using, but it isn't working.
=[Q1 2019 NBR OF LOCATIONS]22 + [Q2 2019 NBR OF LOCATIONS]44 + [Q3 2019 NBR OF LOCATIONS]81 + [Q4 2019 NBR OF LOCATIONS…
Formulas and Functions11Kitty
I've discovered that text is no longer behaving well within the cell. I'm see words cut off within the cell, whether or not the cell is formatted to wrap the text.
Thus, it makes copying the text and pasting it wonky. I oft…
Using Smartsheet80Loann McGee
I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box.
In other words, there are two columns to include in the count from my Comm…
Formulas and Functions113slilienfeld113476
I have a drop-down list of names on my sheet. I need to remove one of the names and add a new name, but I want to keep the list in alphabetical order. I can't find a way to re-order the names in the dialog box where I add the new name. Do…
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions65KDub618
Sometimes more than 1 course is taught at the same location. I am being asked to count the number of courses taught, quarterly. On rare occasions, a course is not taught and OTHER is entered in that column. (OTHER could mean initial meeti…
Here is my formula, and S/S does not like it.
= [National Instructor 1 Numerator]@row + [National Instructor 2 Numerator]@row + [National Instructor 3 Numerator]@row + [National Instructor 4 Numerator]@row
Am I missing something? I c…
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me.
Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from …
Formulas and Functions39cthrasher97141
I have a multi column Smartsheet that tracks items by date. Part of the functionality shows the number of days the item has been active:-
=IF(OR([S.Status]5 = 3, [S.Status]5 = 1), TODAY(0) - [Start Date]5)
There is also a check box col…
Formulas and Functions46mo'connor113211
My team is looking to connect with other Smartsheet users to share ideas on how we leverage Smartsheet to manage tasks and projects. Now that our department is growing, it is crucial that we refine our Smartsheet work space and how…
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - w…
I have many forms - which are requests that need approval. When I create the approval workflow, it sends 2 buttons - Approve or Decline. I need more. I need a NOTES section for when it is denied so that the reason can be recorded on my …
= IF[Instructor 1 Last Name]@row = "" - AND [Instructor Status]@row = "U.S. Instructor" - I need it to count as 1. Otherwise, 0.
What I've written above is what I want to do. Below is the formula, which gives me the …
I am trying to find a way on the Smartsheet web form to display the Name from the contact list, but not the email address. This is a public form, and while I want to be able to alert the event coordinator that something has been submitted,…
Using Smartsheet39[email protected]
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down?
Below is the formula in E…
Archived 2017 Posts79Michael.Baker
One of the users mistakenly unsubscribed from the workflow email notification, how can they be subscribed again to this particular workflow?
I'm trying to count instances of a specific selection in a multi-select column when "Yes" is in another column. I've tried various FIND, COUNT, COUNTIF, COUNTIFS then IF or AND, but I'm not able to figure this one out.
Formulas and Functions85tmccray
I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements.
In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the onl…
Archived 2015 Posts720Loann McGee
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more contex…
I have problem with the dates in the formula below (in sheet summary)
=AVERAGEIF([Date of request]:[Date of request], >07.01.2019, [Completed in days]:[Completed in days])
The Smartsheet returns me the value 0 that is wrong ca…
Formulas and Functions55Pilarmonia
I created a report from a sheet. The report contains only a few columns. This report is intended to be mostly used for calendar view. The items we want viewable in the calendar are the same items contained in the report -- not the main …