-
Conditional formatting
Hello, How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red? Is that possible?
-
Sheet Formula
Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying to get it to count all the dates in the column, but I also want to use to the formula to count all the rows with that same…
-
IF HAS Formula to Return Email in Contact Field
Hi, I have a sheet that includes a multiselect contact field with RA names (On-Site RA(s))and a second contact field (Manager). When joesmith@email.com is one of the emails in the On-Site RA(s) field, I want maryjones@email.com returned in the Manager field. I have added the IF HAS formula you see in the example in the…
-
Mapping data within a hierarchy
Hello, I hope you are well. I'm trying to find a way to collect information within a hierarchy on a sheet. I need to gather the last date for a column within a level of the hierarchy and display this date in the parent cell of this hierarchy, regardless of whether new rows are added during the project's development. The…
-
SUMIF Formula ?
Hello! I am trying to make the following formula. If "Actuals (Cash-In-Hand)" is greater than "Budget" list the overperformance difference in "Over-Performance". If there is an underperformance it should stay $0.00. In this case the overperformance is $1,185,852.00. Thank you for your help!
-
New user here... Need formula on how to count how many entries in a column are in a specific month
Hey there, I have wracked my brain for hours trying to find a formula that will allow me to count how many cells contain the month Jan, Feb, etc. So far I have tried the following.. Please let me know how I should adjust: =COUNTIFS({[ Range 1]}, @cell >= DATE(2024, 1, 1), {Certificate of Destruction Range 1}), @cell…
-
Date Percentage Formula Help
I need help with a formula. I have two date-formatted columns ("Archives Start Date" and "Archives End Date") and I need a formula that displays essentially "as of today, we're X% of the way between those two dates". Any help is greatly appreciated.
-
Remove duplicates from a row?
Is there a way to remove duplicate zip codes in a row of columns so only unique zip codes will be available when I concatenate them all into a combined zip code column? Example: If I have 4 columns of zip codes and Col 1 and Col 4 are duplicates, I only want to show Col 1's Zip Code once when I combined all the columns…
-
Formula not displaying percentage
I would like to display the most recent data from a cell in the metadata section of my Status Tracker sheet. Every week someone will manually update this information by adding a new date and then manually entering the percentage complete. All of the information at the to pulls in the most recent update in all of the cells…
-
Formula to get best poll time
I have created a poll with dates as column headers and several times as multi-drop down options. It created a fantastic web-form I was able to share easily with collaborators both inside and outside my organization. My question is, is there a formula I could apply in the Sheet summary to count the best time for each date,…