-
📣 Smartsheet is Hitting the Road: Join Us In Person!
We’re bringing the Smartsheet community together across several cities, and we’d love to see you there! These interactive User Group sessions are your chance to level up your processes and connect with peers. 📍 Sydney, AUS When: Thurs, Mar. 12 | 9:00 AM – 11:00 AM AEDT 📍 Stockholm, SE When: Thurs, Mar. 12 | 1:00 PM – 6:00…
-
Welcome to the Healthcare & Life Sciences Community!
This is a space for Smartsheet users that work in the Healthcare and Life Sciences industry to connect, share ideas, challenges, best practices and how you are using Smartsheet to transform Healthcare & Life Sciences. Our Smartsheet team will be sharing helpful resources, upcoming industry events, discussion questions, and…
-
Creating a formatted/merged email from a grid
I have a complicated workflow that I'd like to significantly reduce, in terms of time spent. Working from a standard grid, I need to format the email, pulling some summary information for a project and then adding specifics for each individual tied to each project. A few points: the summary information is currently in a…
-
Complex Automation
In a sheet, in the primary column (Task Name), I have multiple parent rows with all of the same child rows beneath each parent row. A simplified example is each Parent Row is a new lot number, with two associated child rows called "Date of Shipment" and Date COA". There is also a drop down Status column. I want to create…
-
Conditional Formatting in Rows Resulting from Formulas
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…
-
Countifs + contains with reference form another sheet
Trying to reference another sheet with the COUNTIFS + CONTAINS formula and am getting this #INCORRECT ARGUMENT SET Here is the formula I am using =COUNTIFS({ReturnOrder}, Date@row , CONTAINS("STS", {Companyname}))
-
How to quickly find a column by it's name in a sheet?
I have a very large sheet with many columns coming in from a form and many additional helper and result columns. I have created documentation of how it is working where I document the column named, its purpose and the formula used. (In addition to adding information to the column description). I am curious if there is a…
-
Jump to column feature
One of my biggest pet peeves is when a Smartsheet is set up with the first row as column names so that you can control + F column name. Without it is a nightmare of sorting through all the different columns trying to find a specific column looking for, so I get it, but I just don’t like it. Fix it, please Smartsheet. I’m…
-
My Sort Option is Greyed Out
Hello, For some reason, I am unable to sort my columns. I am attempting to sort my first column alphabetically. When I right click on the columns (any) the sort option it greyed out. My other column have drop down settings. I appreciate any help!
-
Separating Text Formula
Hello, I am trying to create a formula that will separate text. I can't use the Left or Right and the length of names is different. Example: I need to return the first name only in a different column. Format is LastName, First Name Full Name First Name Smith, Joe Joe Jones, Ralph Thompson, Leah Robbins, Sam Robinson, Sally…