-
what is the formula to collect Sprint no, based on the start date for a task from another sheet
I'm trying to use =INDEX(COLLECT({Project PI & Sprint-Primary Column}, {Project PI & Sprint-Start Date}, <=[Start Date]@row), {Project PI & Sprint-End Date}, >=[End Date]@row, 1) but its not working I want to add a formula in this sheet to provide Sprint # based on the start and end date for the task, refrencing to another…
-
How do I set up an inventory management system in Smartsheet?
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 each day. I'm looking to create a system where they can input their daily needs, and it will show how many of each item is…
-
Need a formula where the children rows = the parent rows
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.
-
formula not showing Dollar symbol
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 the dollar symbol in Column (A) to be present in columns (B) & (C) =IF(ISBLANK([unique.invoice]@row), "",…
-
Can you automatically populate the Owners list?
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, then Task Owner(s) = Bob If Task Team = Training, then Task Owner(s) = Kathy and John
-
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…
-
Max and index match function
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 number and i want it to pull the recent entry date of the trailer and the Load number / po that came in that trailer. How can…
-
COUNT Formula for counting number of comments in another sheet
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?
-
VLOOKUP/INDEX/IF Help?
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 matching the Part Numbers in both sheets, circled in red. In a perfect world, an employee would enter their daily work report…
-
Nested Index Collect to gather data from multiple sheets
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. The basic formula from one sheet works: =IFERROR(INDEX(COLLECT({Sheet1 Person}, {Sheet1 Client}, Client@row), 1,),…