-
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,),…
-
VLOOKUP and COUNTIFS
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 VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
-
Whats the formula to find todays date between a range of dates to provide a value?
i need a formula to find todays date between the start date and end date, then provide the current sprint
-
Using WebHooks & API to create your own custom Column Functions
I thought it might be useful to share a general method I developed to add Functions missing from Smartsheet. This technique makes use of WebHooks & the API. Most important: users can add this to their sheets nearly as easily as they can add formulas. They do NOT need my help as a programmer For example here are a couple…
