-
What formula would I use to pull text into a new column?
I want to use a formula to isolate the training type into a single column. Currently, "Training Type" is a primary column so I am unable to make it a dropdown selection and automation would take too long to do (there are over 100 rows). So I want to use a formula to isolate the training type from the "Business Segment, RCM…
-
Contact List Functionality in Forms
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user within our Smartsheet account when you begin typing a name. However, when attempting to use this within a form, it DOES NOT…
-
Unified DocuSign tracking column
Thank you SmartSheet team, for all your hard work on the DocuSign integration. We're in the process of putting together some automations to take full advantage of this feature. Meanwhile, I'm trying to avoid creating multiple DocuSign tracking columns every time I generate>create and connect a new document to a different…
-
Increase Import Column Capacity
Currently it will not let you import anything that exceeds 400 columns. This is very frustrating when your trying to import data into a sheet. I have found myself having to copy & paste the data in by hand. Increasing the capacity would be extremely helpful. I am transitioning all our excel files into Smartsheet sheets to…
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula. This is what I have: And this is the message that pops up when I try to convert it to a column formula: I just don't want to continue to drag the formula down with each…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that pops up when I try to convert it to a column formula: I like the current formula because it allows me to set up my Request…
-
Assigned to column with avatar only setting
Hi! The assigned to column works well, and I like seeing everyone's name. However, it would be very helpful to have a "quick indicator" nearer to the project name as to who is assigned this task (or to update the column without scrolling over to the assigned to column). It would be nice to be able to choose an "avatar…
-
Set Contact field display type to name or email
When using Assigned To or any other contact field across a large number of sheets, and then aggregating that data in a report or pivot that groups by the contact field, it becomes quickly painful that the same contact appears as both their email address and their name, depending on how someone entered them into the Contact…
-
Select Multiple Values Using IF Formula In MultiSelect Dropdown
Hi Smartsheet Community, Recently I've been working on a column that allows me to assign required approvals based on certain roles (see below). I want to create a formula that can output an role if it's associated contact has been filled in or not. So for the example below, I would like it to output Project Owner AND Man &…