-
Date Calculations
Hi there, I am trying to do a simple formula for a date to automatically populate in the Date Due column. I take the Event date and subtract the number of days prior to the meeting for each individual due date. This is the formula I created. However, when I run this formula in the Date Due column, nothing is returned. What…
-
Determine how many projects are active during given period
Hi all, I was wondering if anyone can help? I've got quite a number of projects running from Timepoint A to Timepoint B (several months) and wondered if it was possible to write a formula in my (separate or the same sheet) metrics sheet to determine how many projects are active during given month? For instance, I have 5…
-
Index/collect/join-match formula when source sheet row meets multiple criteria
Hello! I'd like to apologise beforehand, but my brain is fried at this point. I do believe it's something easy and I did go through similar entries on this forum prior to posting this. I'd like to have a cross-sheet formula where, once certain criteria of cell values are met in the source sheet, it will update my date.…
-
Determining "In Stock" From an Inventory Library by Matching SKU
I have two sheets: Inventory Library and an Order To-Do List. I want to be able to check a box marked "In Stock" if the Inventory Library shows that the matching SKU has more than 0 in stock. I am trying to use an Index and Match Function to return the actual stock number in the Order sheet and then format the checkbox to…
-
Add the emails as hyperlinks - get it recognized by contact list
Hi All, is this function supported: =Alias@row&"@email.com" - in the 'Alias' column I have logins & I would like to add to this aliases in another column also the domain: "@email.com" so they get recognized by the contact list. Thanks - Viktor
-
I need a formula to clear contents in a field if the date in another cell is in the past.
For our process documentation review cycle, we have a column for Date of Next Review. There is a column next to it, Reviewed Process, that has a dropdown to indicate if the document has been uploaded to our Sharepoint site. If the date of next review is in the past, I need the contents in the Reviewed Process column to…
-
Date over 30 days = "text" formula help
I have a column where a date will be entered. Based on that date in another column, I want to state "Pending" if the date is over 30 days past the original entry date. =IF([DeliveryDate]@row > TODAY(+30), "Pending") I'm not getting errors with this, however, the text "Pending" is not displaying when the DeliveryDate is…
-
COUNTIF (Counting a column based on other column Information)
Using 2 columns (Status) & (Tracking) I'm trying to count the amount of "complete" status in the Status column where the Tracking column is not Past Due. Below is the formula I created. =COUNTIF(AND(Tracking:Tracking, <>"Past Due", Status:Status, "Complete")) It's not taking the formula, any thoughts? Bonus Question* ***…
-
Is this even possible?
I have a process document with columns with start dates and due dates. The process steps do not change from year to year. What I would like to do is trigger some action or create a formula that once an item is checked complete, the start date and due dates advance by 365 days. It would be great if the complete box was then…
-
Formula skipping rows
Hi all, I'm trying to use the below function to automatically change the color of Harvey balls to red, yellow, or green based on the length of time till a task's due date. =IF([Due Date]@row >= TODAY(+61), "Green", IF([Due Date]@row >= TODAY(=31), "Yellow", "Red")) However, for some reason some rows show "#invalid…