Formulas
Discussion List
- Hello, I'm looking for help setting up an inventory management system in Smartsheet. We have a set number of chairs, tables, linens, projectors, etc. that various departments at my organization use ea…
- I need a formula that makes all the rows under PPA say "PPA" in the same column. I need the parent row name to basically fill in all the children row names all within the same column.
- I have column (B) join collect Items @row. I have Column (C) join collecting multiple Column (B) items based on unique values. =JOIN([Cost Center]3:[Rec'd Approval From 2]3, "-") I would like to have …
- I have two columns: Task Team & Task Owner(s) Is it possible to automatically populate the Task Owner(s) column based on the value entered in the Task Team column? Example: If Task Team = Technical, t…
- 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 l…
- Hi all, i have a sheet where Trailers are logged in multiple time throughout the day and what they had in them such as a PO number or a load number in a separate sheet i want to type in the Trailer nu…
- Hi! I am trying to figure out how to write a COUNT formula to count the number of comments in another sheet by using a cross-sheet reference. How do you include a comment count in a Smartsheet formula…
- Hello, I'm attempting to integrate data between a "Master" sheet and a "Daily Entry" form. I'm trying to populate the "Quantity Completed" with the value in the "Parts Run" cell after successfully mat…
- Hi all, I am trying to create a sheet that pulls data from multiple others. I want to populate the person from Sheet 1 when the collection sheet column for client matches the Sheet 1 column for client…
- Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the …
