-
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,…
-
Properly using Max(collect)
I am trying to get Column37 to output the value in the "Is the employee currently off" column. I don't understand why this is not finding a match. I have done this exact same thing in another sheet and it works perfectly but for some reason, this is not matching Here is the other one, which works for some reason.
