-
I need help with a formula
I am working on my {main sheet} and referencing a sheet named {tracking} I am trying to return a value of a cell if the "dates" match and the "names" match in my {main sheet} and my {tracking sheet}, it should return a value from the {tracking sheet}. Does anyone understand this? Thank you, D
-
Better formula method of tracking statistics by row - it clutters up the sheet too much.
We have a sheet that tracks assets and the process of their development. We also have a report that shows how many assets and associated tasks are coming up in the next 8 weeks (by week) for allocating resources. I have added numerous columns that calculate (based on dates) when the asset is due and how many tasks…
-
Right and MID formula to pull from details sheet
I have imported my excel budget and details sheets into Smartsheet and unfortunately my formulas don't import correctly. I have struggled with rebuilding my formulas from excel to Smartsheet and that is the case with the below: =RIGHT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255),5) How do I rewrite this in…
-
Receiving #INVALID OPERATOR when using AVERAGEIF
Hello, I'm trying to average the value of Opportunity Age (Days) in a cell when Sales Stage contains "Won". I'm receiving an #INVALID OPERATOR for the following: =AVERAGEIF([Opportunity Age (Days)]:[Opportunity Age (Days)], [Sales Stage]:[Sales Stage], (CONTAINS("Won", @cell))) Any tips you could provide would be greatly…
-
Sum of True/False (1/0)
Hi, I am using this formula to search a multi-select column for if that column contains "IDS". =IF(CONTAINS("IDS", [Define Resource Needs]@row:[Define Resource Needs]@row), "1", "0") It is returning the 0 or 1 to me just fine - but what I want is a sum of the instances of "1". This will give me a count of how many times in…
-
COUNTIFS with date range as criteria.
I am trying to use the COUNTIFS formula with a date range. Here is what I have: 2 sheets Attainment sheet (This is where the formula is) Schedule sheet On the Schedule sheet, I am looking at 2 columns Schedule Range 2 = Team column Schedule Range 3 = Service Date column I am trying to see if the Team column contains a…
-
Using Smartsheet Template "Project Issues Log"
The Product Issues Log is a template from the Creating Risk and Issues log training. This template is supposed to automatically move an item from the Open area of the sheet to the lower closed area when it is closed. I know there is something that has to do with the formatting of the issue in the description column that…
-
Reporting a Change to Dates
I am would like to send out a notification when a due date has change that has what the date was and the new date. Example The Timing has changed for Job # J00342-T0001-01-Bar Light-Plug-1st-Project Name-Prep & Ship Ship as changed from: Ship Date-09/06/19 Ship as changed to: Ship Date-09/06/24 What would be the best way…
-
SUMIFS - How to include multiple "Criterion" in a "Range"
I am sure there is a simple solve but it doesn't seem to be working for me. I am trying to use the COUNTIFS formula, with 2 ranges in included. The first range ("Status") is straight forward as I only want to select one criterion ("In Progress). In the second range ("Division"), I want to select multiple criterion (i.e.…
-
SUMIF
I have a sheet with values, Dates created and Sales Person. There are multiple Sales Persons attached to multiple values and dates created. I have used SUMIF to gather and total the values per month. =SUMIF(Created1:Created211, MONTH(@cell) = 8, [Contract Value]1:[Contract Value]211) How can I also break the values down…