-
Using the difference between dates in an IF statement
I have a column the calculates the number of days between 2 dates, which is fine. =[Arch Prelims]@row - [FP Arch Engagement ]@row (gives me a number) But I don't want to do the calculation if the difference is a negative number. There are few instances where the result would be a negative number (very few) I don't want to…
-
Formula Query - Nested IF Statement
Hi, i have a problem where i am tendering on projects, where i request quotes, input the prices, then i will adpot the price i wish to use that makes up the total. Im struggling to get the formula right. Basically it should be the Quantity x Rate, unless it has children and the "star icon" is checked, in which case it will…
-
Sum if week is the same - or blank if none
Good afternoon, I'm sorry for a somewhat redundant question but I've not been able to get this to work. I need to sum up the hours if the days are in the same week. But, if no date, leave it blank. I have a date column that could be used and a week of the month column. This is one of many formulas I've tried.…
-
Date Range in Date Column + Automation
Hello! I have an automation that currently sends users alerts based on the date in a column called "End Date". A majority of the time, the end date is a single date. However, sometimes the end date can be two or more days (ie- May 7th-8th). While I can write into the date column ="May 7th-8th", that will prevent my…
-
Keyboard shortcut to delete a row
Hi Everyone, I am used to working in excel and using keyboard shortcuts to navigate my sheets without having to use a mouse. Is there a keyboard shortcut to delete a row? if not can how do I let the product team know to add this to the development queue? thanks!
-
Stumped on an Unparseable formula
Hi all, I have a formula: =IF([New (Feb 2025) Account Coordinator]@row = "Carrisa Meeks", "GS 1 - WAREHOUSE") where if the column "New (Feb 2025) Account Coordinator shows Carrisa Meeks, then the cell should populate "GS 1 - WAREHOUSE". It works for all the other cells, exactly the same with a different column name and…
-
Formula to Create a List of Non-Filled Cells in a Row (ignoring the first column)?
Hi, I have a sheet that lists a bunch of documents in the primary column. The additional columns list out the names of people who either get access to those documents, or don't. The corresponding cells are filled in with green or left blank depending on their access. I am trying to create a formula that will spit out a…
-
INDEX MATCH Formula
Hi, I used this formula in one column on Sheet 1, it looks at Sheet 2 and finds the Site Name and if the Status is Committed, it pulls in the number of Committed Trees. It works just fine for the Committed Trees column. =IF(INDEX({Inventory Agreements - Status}, MATCH([Site Name]@row, {Inventory - Site Name}, 0)) =…
-
Why is DATEONLY() returning the wrong date?
Hello All, Does anyone understand the behavior of the highlighted cell below? I believe it should be displaying "08/18/20".
-
JOIN only if cell is not blank
Hi there, Is there a way I can use the JOIN function to merge the contents of an entire row from another sheet, but exclude rows that are blank? The contents of the other sheet is generated from a form (and being constantly updated), so referencing the entire column is the only option unfortunately. It seems like it should…