-
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.
-
How to get an "Average" of statuses
Hi team, I am trying to find the best formula to get an average of statuses. I have a helper sheet build out for this purpose. I have certain sub-goals and several projects tied to these sub-goals, each of the projects has a status - not started, in progress and complete. I am trying to find a formula where out of these…
-
SUM IF Formula
Hi I am trying to sum the number of days based on a criteria - I'm expecting a 6 to come back but, instead I'm getting a 0 I know its something super simple but, I've been looking at this for ages now and can't workout what the issue is! TIA Cheryl