-
How may I extract only the numbers from a cell?
I need to extract 16 and 9. As you can see the number characthers may change (I may have 1-2 digits) but always at the beginning. Thanks
-
Edit Task (sheet row) from Dashboard
I have created a dashboard that list tasks by "Past Due", "Due Today" and "Due in the Next 1O Days". I am using reports for each of those sections. (see pic) MY GOAL: My ultimate goal is to allow all end users to click on a task in the list and open a form (or in "Card View Editor") so that they can update them. WHERE I…
-
formula
Hi Guys I am needing help with another formula, in another sheet I want to extract data from the sheet above I want to get an average of days (green Highlighted amounts) is IF DEPT contains REF what is the average of Green Highlighted amounts) and the same for NIS and SSS
-
Data a file was last modified?
Hi, I have 44 project plan files and I need to generate a report each month that will tell me the most recent date each of these files was modified (i.e. the file was last saved). I am trying to add a forumla into a dummry column in each file to then enable me to report on that column but I cant get any of the suggested…
-
Work due in the next 7 days
Where am I going wrong with this formula? I want to see tasks that have a {Need by Date} of TODAY through the next 7 Days and also filter out any Assignee's {Task Range 1} that say "Schedule Milestone"? Thanks for everyones support on this one :) Both of the datasets would both be pulling from another sheet.…
-
Can I ignore a row that is missing data and is corrupting my formulas?
I am having an issue where if there is 1 or multiple rows that are mising the key dates it throws the formulas i have set at the top of my sheet out of whack. For example "Mark Wendling" doesnt have the dates to calculate for "Projected Build Time (Months) (Elliot)" , "Months Difference to Contract-Late +Early (Elliot)" ,…
-
Custom Number Formats?
Rather than showing a 0 in a cell, I'd like it be be blank or use the " - " symbol. In excel I use custom number formats to accomplish this. First, I tried conditional formatting to a white (invisible) font, but it doesn't look like i can limit the rule to certain cells (only an entire row or column) so that won't work if…
-
SUM Formula Does not work with Quarter Formula
This is my test sheet. I have the following formula in Quarter column: =IFERROR(IF(MONTH([Contract Acceptance Date]@row) <= 3, "1", IF(MONTH([Contract Acceptance Date]@row) <= 6, "2", IF(MONTH([Contract Acceptance Date]@row) <= 9, "3", "4"))), "") The above works fine. I want to summarize sales by the 3rd quarter, so I…
-
Referencing 2 ranges in another sheet
Hi all, I'm trying to use data from another sheet to get a count. I have 2 relevant columns in the reference sheet, Name and Date. I'm trying to count the number of dates for a given name in the last 30 days. Here's the formula I'm trying to use: =COUNTIF({Hiring Actuals Range 1}, ="Smith, John", {Hiring Actuals Range 2},…
-
Using reports
I have a sheet that is updated daily. I am trying to create a report that shows the previous 7 days worth of entries. I could not figure out how to do this so I created a helper column that checks a box for items that have a date up to 7 days prior to TODAY. However, if I don't do into the main sheet every day and save,…