-
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…
-
Math Formula Error
Hi, I am trying to create a formula to divide the Impressions column by 1,000 then multiply it by the Total Price column. This is the formula I am using "=VALUE(Impressions@row / 1000) * VALUE([Total Price]@row)". Not sure what's going wrong. Total price is a column formula that auto fills each cell with the $5.95 price…
-
How to count number of completed projects in a date range?
I am absolutely new to formulas and I'm struggling to find a way to count the number of completed projects during a 14-day range so I can share that information in graph form on a bi-weekly report. I have a tracker with fields for "status" and "actual completion date". I need to count the number of projects that have…