Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Document Builder - Downloaded File SizeIn Using SmartsheetHello, I understand you have to have a fillable PDF when using document builder to map your sheet fields, which already run as a large file. When I generate a document with the populated fields, the file size becomes much larger. Is ther…
-
#INVALID OPERATION ErrorIn Formulas and FunctionsQuestion: Is it possible to write a SUMIFS column formula to add up specific cells in an adjacent column where the criteria are also in other adjacent columns? (Actually, I know it's possible, because the formula I wrote a couple days ago …
-
I need a form to auto populate in some cells from another sheet. Could you help? thanksIn Formulas and FunctionsI need a form to auto populate in some cells from another sheet. Could you help? thanksAnswered - Pending Review 5 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
For Multi-Contact cell is there a way to keep the contacts in the order they are inputed?In Using SmartsheetEvery time I add a contact it arranges them alphabetically, is there any way of keeping them in the order they are entered in?
-
Search on a text string to return all valuesIn Formulas and FunctionsHello My Fellow Smartsheet Gurus, Is it possible to run a formula based on the text inputted in the column next to it to pull all possible values? I am trying to accommodate multiple ways of finding medication names where an exact match i…Answered - Pending Review 2 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
One off Saturdays in GanttIn Using SmartsheetHi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of o…
-
Pictures using Windows Devices on formsIn Using SmartsheetDoes anyone know a way to directly take a picture and attach it to a form on a windows device? I have several microsoft surfaces, and I can't get the option to directly attach a picture to a form like you can with a phone, instead I have t…
-
Is there a way to prevent cell value assigned by formula from changing after sorting?In Formulas and FunctionsWe need to assign a number and letter combination in each row of a sheet. Some rows are considered to be "in a series" and will need the same number but a different letter, i.e. 40001A, 40001B, and 40001C. We have a formula that…Answered - Pending Review 8 views 1 comment 0 points Most recent by Toufong Vang Formulas and Functions
-
NOT include "complete" or "removed" in my CountIfsIn Formulas and FunctionsI am trying to get the count if my acquisition New has a go live date between 2 dates but not include those that have been marked as complete or removed. Here is the formula I currently have, I'm getting an incomplete argument. =COUNTIFS…
-
Workflow or function that alerts me when something repeatsIn Formulas and FunctionsI would like to set up an automation or function that alerts me when something is repeated in a sheet 3 times in a 30-day period. The trigger could be taken from a drop down menu, i.e the location "ABC Lane" has been chosen in a …Answered - Pending Review 2 views 8 comments 0 points Most recent by Jamie Paraf Formulas and Functions
