-
IF Function
Hi, I want a formula to report if the Actual Start date is greater than the Baseline start then put the tick and cross symbol. The formula works however even when there is no actual start date entered it will still populate. I need a condition for if it is blank then no symbol appears. Can anyone please help me out? :)…
-
We have products with expiration dates and we need a cell to count them in a range of days.
We have a column with expiration date that is put in manually by an employee with the rest of the data when received. Currently we have conditional formatting to highlight the products expiring within 30 days via the row turning yellow. We need a cell that will automatically count and display a value for all yellow…
-
Vlookup #no match error only on one element in range...
I am wrecking my brains trying to figure out why my vlookup returns #NO MATCH result for one of my selection options, but all other options are working? What am I missing...can someone please put me out of my misery... 😂 I have checked spelling, spaces....it will probably be something stupid..but I am stumped...…
-
Using Formula - Display Wednesday of Every Week based on Submitted Date
I have a publication that's sent out every Wednesday and allows people to submit articles to show up in the weekly publication. I need help writing a formula that would make the "Publish Date" column anything submitted between Thursday-Wednesday to show that week's Wednesday date and everything outside to show the…
-
Checking for conflicting assignment dates across two columns
Long time reader, first time poster--this one has a few people stumped. I have a variety of events with Start Dates & End Dates. Staff members are assigned as a 1st Guide or 2nd Guide (its critical we differentiate which role they have been assigned). I am looking for a way to pop a warning symbol when one of the names is…
-
Unique instances based off of 2 columns
Hello, I need help with a formula that would count unique instances in 1 column based of information in another column. Please see below, how do I count the number of unique names there are in column 1 based off the name "Yvan" in column 3. Thank you in advanced for your assistance
-
Using Join, collect, and contains with a multiselect column
Hello, I'm trying to see if I can extract a location's email address into a multi contact column but I seem to be hitting a bit of a wall when someone selects two or more entries in their location. The contact emails are listed on a separate sheet but both sheets share the same location naming. =JOIN(COLLECT({Location…
-
IF Function using different criteria under the same column
Hello everybody, I need your help with IF Function . I have 5 criteria under the Country column and I want to assign codes for each country. So, IF is “Chile” then code to be 9 IF is “China” then code to be 8 IF is “Colombia” then code to be 7 IF is "Costa Rica" then code to be 6 I’ve been trying numerous times to group…
-
Index/Match/Max Function Issues
@Paul Newcome @Andrée Starå I am having issues matching a cell value from my project status column. My goal is to reference my most recently updated (max modified cell) data entry and return that value in the selected cell. My current formula for reference: =INDEX([Project (Schedule) Status]3: [Project (Schedule)…
-
Correct IF Formula for updating "expiration status" dropdown based on dates
Hello Team. I am setting up a sheet that would help track and act on over 3K documents based on their end dates. The two column I would like to work together are "end dates" and "expiration status". The "expiration status" column is a dropdown with the following choices: "Current" "up to 1 year expiry" "6 mos. expiry" "90…