-
Column Formula
I'm using this formula, =WORKDAY([End Date]@row, -2, Holidays:Holidays), to allow me to send a notification 2 days prior to an upcoming event, minus weekends and Holidays which I have define in a separate column. I need to be able to send my notification if the event happens within the 0-2 window as well. Meaning I want my…
-
If function for children rows
Hi all, I don't know how to build a formula for the following: I want the parent row to show ''Pass'' when ''Pass'' is filled in for ALL children rows. If one or more of the children rows has ''Fail'' or ''Suspend'', I want the parent row to show ''Fail''. The children rows refer to the children rows of the parent cell.…
-
Hyperlink to local files - When is this being added?
I'm trying to find a way to put a link to a local network file in a Cell. I get "invalid URL" when I try and add it to a cell. We have a huge list of locally stored files that we cannot store on the cloud due to the sensitive nature of the documents. Having the ability to hyperlink direct to the internal network would be a…
-
Convert text (19-NOV-2020 11:30:38 AM) into date
Hello, I am looking for a way to convert text in the following format: 19-NOV-2020 11:30:38 AM into a full date (with hour and minutes). Any suggestions? Thanks
-
Holding A Column Position in VLOOKUP Formula
Issue = Within my VLOOKUP formula =VLOOKUP([Example]1, {Test}, 16) the column position is 16. If at some point a column is inserted to the left of column 16 in sheet {Test} then my VLOOKUP formula returns incorrect data! Question = Is it possible to get my VLOOKUP formula to hold to the column itself rather than its number…
-
COUNTIF with Range
Hello! I'm using a COUNTIF formula to reference the number of times columns from a form are answered yes and no in the last two weeks. =COUNTIF({Range 3}, "No") The problem is when new forms are completed, the responses appear at the top of my sheet. I only want the range to be entries from the last two weeks (28 total),…
-
Index Match or Index Collect with multiple criteria
I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row, {Scope of Work}, [Scope of Work]@row)) Solutions? 😁
-
SUMIFS between specific cells
Hi! I want to sum the values in a column only if the values are between cells 2 to 729 and only if "Nina Gallagher" is in the "Who" column I've gotten this far -- =SUMIFS([10/5/20]:[10/5/20], Who:Who, ="Nina Gallagher") When I try this, I get #INCORRECT ARGUMENT -- =SUMIFS([10/5/20]2:[10/5/20]729, Who:Who, ="Nina…
-
Remove space and the letter after
Hi - I have a column with a list of names. Some name has first name, a space then middle initial and some has only the first name. See below example. I'm trying to work a formula that take only the first name without the middle initial. I tried this =LEFT([First Name]@row, FIND(" ", [First Name]@row) - 1), but it show…
-
How can I find all active notifications and workflows in a workspace?
I have a prolific workspace for a completed project that belong to another user who is no longer using the sheets but still owns admin rights. There are still some live automated notifications and line specific update requests being sent from sheets in this workspace. Is there a way to find them to get them shut off…