-
MIN & MAX Collect Formula Help
I am trying to write a cross sheet formula that evaluates dates based on a matching project ID on the source sheet and return a date value in the target sheet (where the formula is being written). The formula should: Look up dates in a column on another (source) sheet. Each row on this sheet has a unique ID. Only evaluate…
-
SUMIF OR SUMIFS
I hope I can explain this correctly. I have three separate columns I am working with. My goal is to sum the total footage of certain rows that have been approved within the last 7 days. My columns are: FOOTAGE, STATUS, and DATE APPROVED. I would like to have a total in a separate cell at the top of the sheet. I keep…
-
Replacing all special characters in form query string parameters with a formula
Hello everyone! I am excited to be speaking at the "Leveraging the Query String in Forms" session at Engage 23! I wanted to share a formula that a customer and I developed to replace any special characters that could show up in cell when you are building a URL to a form with query string parameters using a formula. This…
-
Countif formuls
I'm trying to have a countif formula for a column that will count only if the space contains 100%, I can't seem to make it work, this is the formula I tried: =COUNTIF([FAT Completed]1:[FAT Completed]90, ="100%") anyone have any ideas
-
COUNTIF problem
Disregard. The problem was additional dates on collapsed child rows. Thank you. Good afternoon. I have created a metric sheet that was then used to create a chart. The formula is written as: =COUNTIF({Date of Visit}, IFERROR(YEAR(@cell ), 0) = Year@row ) This was then drug down for 4 rows. Rows 1, 2, and 4 have the correct…
-
autopopulate the percentage complete based purely on the time passed
My goal is to have the percentage update automatically each day. If the task has a duration of 45 days and we are 3 days in, I need it to show the percentage complete. It would cap at 100% once it has reached the end date
-
I created a date column to generates dates by adding few fields but I am getting an invalidoperation
my formula is returning number of dates, as in adding dates.
-
Calculate Days Past Due and/or Days to Complete
Problem: I want to calculate the number of days past the End Date or the number of days until the end date. If the End date is less than today, it would be "Overdue by " X days and if the End Date is greater than todays date, it would be "Days to Complete ". If the Status is Not Started or Completed, then leave the field…
-
Formula error - Incorrect argument set
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
-
Formula to count # of tasks overdue based on date
What is a formula to count the # of tasks that are overdue, based on a date?