-
JOIN/INDEX MATCH HELP
Hi all, Is it possible to return multiple values in to a cell based on a match in a cell which may have multiple values? I have 2 sheets - one is my master tracker. I am trying to autopopulate the sub-portfolio Column based on what product or products are selected in the PRODUCTS - OTHER which is a multidropdown column. I…
-
Create a Drop-Down List from Another Smartsheet
Greetings! Does Smartsheet include a feature that allows for the creation of a drop-down in which the selection choices are pulled from a column in another Smartsheet? Thank you, John
-
Looking for a cell value to trigger a formula
I'm looking for a formula to reference the value in a column then run a formula. I am using this to check the status of a contract then run a formula to see if too much time has passed in that status. If contract status is "In Legal" look at date sent to legal and make the value expired if seven days have past.…
-
IF AND STATEMENTS
Hello, I am trying to create an IF(AND) statement, but I cannot figure it out. Any help would be greatly appreciated. I am trying to write a formula that will check the "at risk" if the the "done" column is not checked and the due date is 7 days before today.
-
One Data Set, Multiple Calendars
I have a sheet set up for publishing to Outlook calendar. "PTO Detail" is the primary column and displays on the calendar. I need to create a second calendar with all of the same dates with the second column "PTO Detail Team". What's the best way to go about this? All of the data is input via a form, and both calendars…
-
Counting dates not working
I have 2 sheets. A Master data sheet (sheet 1) and a 2023 blackout calendar(sheet 2). What I am trying to achieve is a formula that counts how many times a date has been scheduled in my master data sheet 1 [Installation Date], which matches/references the 2023 calendar in sheet 2 [Conversion Date], and bring the count into…
-
Help with IF Formula
Hi, I am trying to take a column of zip codes and create a new column that categorizes the zip code into one of 5 NY Neighborhoods. I tried writing my formula out but am stuck. Here is the data: I tried in excel, and in my excel the first cell with a zip is J$7$. Any thoughts? Thanks! :)
-
Multiple IFERROR Fx with INDEX(COLLECT returning Incorrect Argument Error
I'm trying to write a formula, referencing a job number, to pull job due date, checking three different databases, our backlog and then shipment summary and then Order Entry Sheet. I have this formula that works when I pull Part Description: =IFERROR(INDEX(COLLECT({BACKLOG PART DESCRIPTION}, {BACKLOG JOB NUMBER}, [Job…
-
Top 5 Producers Chart Creation
Hello! We want to post a top 5 (or 10) list on a dashboard to dynamically display producers with the top 5/10 highest total sales in both count and $ amount. We have a master sheet to capture this information but cannot find the right formula or approach (maybe a helper column?) to produce this. Any help is greatly…
-
I need a formula that allows the following:
If Modified B has “automation@smartsheet.com” then use Modified By column data but if Modified B is anything else place Modified B data in New Modified By column.
