-
Count IF Between Dates in Excel based on a name
Hello, I want to count the cells that contain a certain name in the assigned to column on one sheet only if the task start date is within a certain date range i.e the current week. For example, count how many times the "Assigned To" column on Project Plan sheet contains the name John Smith The two sheets are Project Plan &…
-
Combine formulas referencing the same cell without running into a circle reference
Is it possible to combine multiple formulas referencing the same cell without running into a circle reference? Similar to passing an object to a function. I would like to combine the 3 formulas below for efficiency sake rather than creating additional columns. =SUM([column name]24/ 1000) =ROUND([column name]24, 1) ="$" +…
-
Adding a $ to a Reformatted Number ending in "M" (Millions)
Hi, I am trying to convert a number in millions but shown as a thousand to the nearest decimal point and then add "M" to the end of the converted number. I understand the formula to divide by 1000 and then use the ROUND function to get one decimal point,but when I concatenate the "M" at the end I loose my dollar sign. Does…
-
How to FIND if the grandparent or parent has a particular word
Hi, Is there a way to find the Grandparent or Parent has a particular string/word? I have tried PARENT(PARENT()) and ANCESTORS(), didn't work. Appreciate any help.
-
Pulling Tasks into a Report Using Multiple IF(AND( formulas in the same cell
My ultimate goal is to pull data into a report from a project plan. I want to pull: * Current tasks (Tasks where TODAY falls between the Start Date and the End Date) * Upcoming Tasks (Tasks where the Start Date is within the next 7 days) * Previous Tasks (Tasks where the End Date is within the previous 7 days) * Late Tasks…
-
Budget vs actual calculation
Hello, I was wondering why the formatting of this document is auto-crossing out the actual calculation? Is it suppose to be doing this? Is there a way to make it not do this?
-
FORMULA - Pulling Data from last row filled
H E L P P L E A S E I have 5 rows (children) of possible data input areas. All 5 rows may not always be used. In Column "M" a number of 1,2 or 3 will be entered. Based on this number, Column "A" of the parent row should reflect "Closed" if the last row containing data is 1 "Work in Progress" if the last row containing data…
-
Automate RYGB and Children together
I have a standard project sheet. I added one column called Today that in Row1 links to a separate sheet that will be triggered everyday so that it gets Today's date (this gets you around using the Today function which only triggers when a sheet is opened), every row below that first row then has a =CellReference the cell…
-
Inbounds to Smartsheets from external sources
I know there are a few connectors for outbound (ODBC) data to all kinds of places but has anybody gone the reverse, i.e. inbound from, say excel, to a sheet. I get the reason to export into tools but I'd think there would be enough cases for being able to pull in data from other places. Anybody?
-
Overlay Google Calendar in SS in a grid
Im going to implement a time management report in the company to understand how the staff spend their time (meetings, planning, execution, travel, etc) To do this we use a name code in Google Calendar that enable us to automate the analysis, like this. * All meeting start with MEETING... * Task-related to projects starts…