-
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
-
Trying to copy rows & then mark them 'done'
I'm trying to do something that seems simple but is really frustrating me. I want to copy certain rows to another sheet and mark them 'done' afterward. I've got an automation that copies rows over to another sheet, then records a date & locks the row. I also want to have it change a value in another cell (mark it…
-
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…
-
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…
-
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…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
Issues with "Record a Date" Automation
Hi all, Any idea why this automation isn't recording a date? We have a formula that's designed to return a value of "Reorder" whenever the inventory for that products dips below a certain threshold. The formula is working, but it's not being recognized as a trigger with the attached automation. Any advice would be much…
-
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?