-
Formula based on last modified date that skips weekends
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
-
Need help with CountIF formula capturing monthly tags
Hi all, I am simply trying to reference each time the business line is mentioned per month. I think I am close? Month number = helper column calculating month. Legacy PCS = the business line I want to count per month. THANK YOU! =COUNTIFS({Month number}, "1", [{Business line}, "Legacy PCS"])
-
VLookup Pulling wrong information
I have a Card Name in the Column in the original sheet. I'm trying to bring the approval data and time back to the cell from "Track Approval" sheet. I'm using the following formula. =VLOOKUP([Card Name]@row, {Track Approval Range 1}, 1, true) What am I doing wrong?
-
Help with using System Created date in a SUMIFS formula
Hello! I am attempting to create a formula in a metric sheet that simply adds a revenue column in another sheet with 2 criteria. 1st criteria is that the "Duration" column = "One Time", the second criteria is where the system generated creation date is greater then/equal to 1/1/2024. I've tried several formulas and am…
-
COUNTIFS with conditions
Hello! I have been trying to get the following formula to work and cannot figure out what is incorrect. =COUNTIFS({US and Canada Tracker Range 5}, >=DATE(2022, 4, 1), {US and Canada Tracker Range 5}, <=DATE(2023, 4, 3), AND({US and Canada Tracker Range 20}, "RA Signed", {US and Canada Tracker Range 21}, "")) Basically, I…
-
#invalid value for index/collect
Hello, I have a source sheet that I need to pull in the Tester when both the AssignID and the LOB match. I tried Match first and then read that Collect is better for this scenario. I figure out why I am getter the invalid value. =(INDEX(COLLECT({Business Assignees Tester}, {Business Assignees AssignID}, AssignID@row,…
-
IF AND find Remaining Duration of a project within 2024
Hi, I am looking for some help with a formula that will calculate the number of days a project will be active in the year 2024. Below are the formulas I currently have plugged. I know that I need to embed something into the Duration Remaining column that will not count days past 12/31/2024.Yet, I am stuck. Total Project…
-
Does anyone know how to count the number of unstarred boxes without adding in the blank rows?
Every time I try to count the number of boxes that aren't starred it counts the rows that are blank as well. How do I only include the rows that are not starred and aren't blank. This is the original formula I used but it is included all rows. =COUNTIF({2024 USPS Audit Failures and Exceptions Range 3}, "0")
-
How to Check Duplicate numbers within 2 columns of data ?
Lets say I have column A and Column B I want to be able to highlight the 123's because they are duped between the 2 columns. How can I do this ?
-
Can we restrict the data selector to a future date?
For example, as for use with a form, can a formula be entered to restrict the calendar/date selector for a date field to not allow a date no sooner than 2 weeks from ()TODAY? Purpose: limiting the request for an event to not be submitted last minute. Making sure there is a two week buffer between requesting and the event…