-
Formula Needed to Check Time From Created Date and Put Into 2 Statuses
Hi All, Trying to work with Created Date column to extract the time from Time Stamp, then look at the time to determine if it falls within two statuses. This is for a Rush Payment Cutoff Time. If an entry is submitted in our sheet before 1pm that day, I want the column to say "Same Day" and if after 1pm, have it say "Next…
-
Getting #UNPARSEABLE and Need Help
Hello Community, I am struggling to figure out why I keep getting #UNPARSEABLE on the below formula. I am trying to add an IF statement for when [CIT PPO #]@row is blank, the result is "Non Compliant". Any help is appreciated! Broken formula: =IFERROR(IF([Job Complete]@row = "", "Non Compliant", IF([CIT PPO #]@row "", "Non…
-
Convert to a Date
So, I have what seems to be a simple date question, but I am unable to find a solution. I need to convert text into a date. Example: 2023-09-01 Need to convert to 9/1/2023 Any ideas?
-
How to capture data (that is constantly changing) between X date and X date
Hi, I'm mainly using a single sheet to track sales information. Within this, there are "stages" for where the lead is in the pipeline. I have a secondary sheet to track the data of how many leads are in each stage. Example: Lead 1 is in the first stage -"Initial Call". Lead 2 is in the second stage -" PM Call". Lead 3 is…
-
Formula for Adding Sums based on Matching
Hello. I created an example for what I am needing help with. I need a formula that sums a column if the value at the row matches a field in another sheet with my current sheet. In my example, sheet 2 is where the formula will live - I need the grand transaction total for each clothing amount so in this example, the formula…
-
Trying to target entire column in a different sheet with a formula
Hi, so what I'm working on is trying to automate status updates between different sheets. The first formula is looking at a status within the same sheet that the formula is written. This formula is working correctly and has no issues. However when including a nested formula to look at a different sheet, that is where that…
-
Column to indicate whether predecessor tasks are complete
I'm looking for a way to add a set of formulas on a sheet that can work together to produce a checkbox showing whether a task's predecessors have been completed. Based on another post I saw, I have gotten to the point of having a column that identifies a row's successors, but can't figure out the formula for the next…
-
IF/AND - reference another table to populate cells
Hi everyone. I have two sheets. The main sheet has information on a number of assets including columns Replacement Year and Replacement Type. The other sheet is an "indicative cost table" with Replacement Type as the primary column followed by each year 2026, 2027, 2028 etc across the top. The cost of replacement by type,…
-
CONTAINS Formula
Hello, I need help with this formula =IF(CONTAINS([Invoice Number]@row, "Invoice"), "Yes", ""). It worked if the "Invoice Number" row value is only "Invoice", if value contains "Invoice xxx" something else after "Invoice" it doesn't put "Yes" in "Want Yes" Row. I would like to put "Yes" in "Want Yes" row if the "Invoice…
-
Need to create a formula that returns multiple values
I need a formula that will return the values in green based on the information in the table. I am pretty new to using complex formulas and I have watched 100+ videos on Join Collect - If Contains and I just can't get it to work. Any help would be appreciated.