-
Formula Help - Phase identifying
Good morning :) I'm trying to figure a way that the row is labeled by the phase of the project that the line is in without having to manually do it. Please see below expected output for 2 phases. I have also attached an excel sheet. I would greatly appreciate any help on this please.…
-
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
-
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
-
Match or Index
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
-
Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
-
Countif, index/match
I'm working on a formula that will return a count based on a matching dates and the word "Quality", but I'm getting the unparseable error. I'm sure it has to do with where I'm putting the ) and ,0 ,1. Here are some that I have tried:
-
Using lookup formulas with Contact Cells
Hello, Trying to sort through an issue I have been having. I am trying to lookup contacts on one sheet against a source sheet to see if they are present. The sheet I am using has the contact in a contact column, but only as an e-mail with no name associated. The source sheet has BOTH the contacts e-mail and name, but by…
-
How to use previous cell value (from cell history) in a formula?
I have seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula? I am specifically trying to…
-
How to perform calculations on individual cells of a range - within a Collect function
Hi folks! I'm trying to do a calculation with ranges inside a Collect function. I'm not getting the correct results. The goal is to calculate a % variance between a forecast amount and an actual amount. This needs to happen 12 times, as this is a monthly forecast/actual combo. The goal is to Count how many projects, run by…
-
Cross-Referencing Another Sheet for Matching and Looking Up Values
Hi! In my first sheet, I have a column "Date Submitted to Courseware". Then, someone selects an "Analysis Priority". First sheet The Analysis Priority should look up the References sheet to the columns for AnalysisPriorityTypeDropDown, match that, and figure in the AnalysisPriorityTypeValue number of days, and figure in…