-
Summing FTE Hours available in the future
I am currently utilizing the current formula =SUMIF({Resource name}, [Resource Name]@row, {Weekly Scheduled Hours}) to determine how many hours a resource has available. Since I began using this, some assignments have ended, but resource utilization is still being summed, resulting in weekly hours scheduled being >40. How…
-
Using IF with greater than or equal to a number
I want the "Complete" column to show "yes" if the total reviews is greater than or equal to 3. I cannot figure out what I did wrong with the formula above. Thanks!
-
How to set a formula to repeat when adding new entries at the top of the page?
I have a sheet that captures employee's leave requests to show up at the top (most recent first)of the "grid" and on the "calendar" and I need it to occur with every entry. How do I set it to ensure that every entry will be displayed and automatically filled with the formula fx=[employee name]1. The formula pulls the…
-
Mulitiple If Statements in a formula
Hello, I am trying to get what stage our project is at from if boxes are filled our checks are checked. =IF([Invoice Number]@row = "", "1. Need Invoice", IF(CLOSED@row = 1, "4.Closed"), IF(AND([Invoice Number]@row > 1, [Paid Date]@row > TODAY() - 365), "3. To Be Closed", "2.Waiting on Payment")) When I do just this it…
-
How to write formula to auto check a column
I have a sheet that tracks our AP process. Three of the four types of payment requests we get require another step. One does not. I would like to have the "next step" column auto check when the "payment request type" is that one anomaly. This can be flied under "are you new here, or what." The answer is , "yes." I've…
-
Nested ISBLANK Formula
Hi I want to be able to look up changes to e.g. employee name, Job Title etc in a sheet and update the any changes on a staff sheet. However, if for example, their job title hasn't changed I need the formula to refer to 'old job title' column. I have a unique identifier of the Employee ID so, wondered if an INDEX MATCH…
-
Date Functions
I am working on a Marketing request form for outside vendors and am curious if a rule can be applied that a due date cannot be before the form was submitted. For example, if a request comes in on 1/1, the requestor cannot ask for a due date before 1/15.
-
Search within all multi-selected fields for duplicates
Hi, I am wondering if there is a way to detect when there are duplicates of a multi-selected item in another row. My formula so far: =IF(OR(ISBLANK(Checkin@row), ISBLANK(Checkout@row)), "", IF(COUNTIFS(Checkout:Checkout, >=(Checkin@row + 1), Checkin:Checkin, <=(Checkout@row - 1), SiteNumber:SiteNumber, SiteNumber@row) - 1…
-
If Then Help
I'd like to have a main input cell for # of items being shipped. Sheet is being set up to ship 40 items. I'd like to have 4 other cells which populate based on the main cell's value. (Example 1) Main Cell: 5 Cell 1 (0-10 Items): 5 Cell 2 (10-20 Items): 0 Cell 3 (20-30 Items): 0 Cell 4 (30-40 Items): 0 (Example 2) Main…
-
Total Time Taken
Good afternoon all, Here we are again, another question about summing up time. I have trawled the forums and cannot find an answer that helps me specifically so I'm hoping that reaching out on here will do so. I have 2 columns - Start Time and Finish Time, the time is put into each in HH:MM format. I would like another…