-
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
-
Formula to copy contents of a sheet to another
I’m new to smartsheet and am trying to figure out a way to call contents of a sheet to another based on certain criteria, something similar to what Filter function does in google sheets. I am aware that I could achieve this using the index collect function, however the data I am trying to call goes in hundreds of rows. Any…
-
IF Function to multiply 2 numbers if the value of a column is greater than 1.99
Hi So I have a current set up in smartsheet, i have the sheet to figure out total time between 2 times. Now I need to do that TOTAL TIME multiplied by No of days BUT Only when the "No of Days" is 2 or greater. Can anybody help with this please?
-
I need a formula that allows the following
If the Created By is Blank then insert the Create By data in the New Created By Column but if Created By is Not Blank then insert the Created By data into the New Created By column.