-
Today Formula not working
Hi, I am trying to use the formula =TODAY() - [Date Issue Opened]1 to populate today date- start date= how many days open. When I type in the formula and try to select the row Date Issue Opened it says #UNPARSEABLE. I have tried using various formulas, so I think it has something to do with selecting the Date Issue Opened.…
-
Check list for another sheet populated by forms fuctions
i have sheet which is populated through forms function i want to create another sheet as a check list which i want to track which locations the forms have been completed. one of the fields in the forms is location, so in my check list sheet im trying to do like a if + vlookup on the location column if it appears in the…
-
IFERROR and number / currency as value_if_error
I have the following columns in my worksheet: In the "Bookings" column, I have the following formula: =IFERROR(INDEX({Bookings Table Total Bookings}, MATCH(pfid@row, {Bookings Table PF}, 0)), "") In my "Adjusted Bookings" column, I have the following formula: =[sbe_allocation]@row * Bookings@row However, as you can see, I…
-
Looking for suggestions - master formula errors report
Hi all, looking for suggestions based on others' experiences. We have a series of dashboards and their respective back end sheets that occasionally throw formula errors for various reasons. I'm hoping I can leach some ideas from the Community on creating a master report/notification that informs us when any error occurs.…
-
Formula help - how to leave blank when Actual Finish is empty
Can someone help complete this formula? - looking for the 'Task Health' column to be empty when Actual Finish is blank, meaning task is not complete yet. Everything I've tried is either unparseable or results in a value. =IF([Actual Finish]@row > [Planned Finish]@row, "Late", IF([Actual Finish]@row = [Planned Finish]@row,…
-
Find all similar entry names and add their qty
Hello I have a sheet I made where I load in all my orders of items needed for a job. Each Item has a code assigned to it I'm calling the Entry Name. There will be times where the same Code/Entry Name will appear several times during the life of the project. For Example This week I might need 4 - BT01 (Entry Name) then as…
-
Flagging bad phone numbers
Hello! I've been reading around and I feel like I'm missing something with my formula: =IF(OR(NOT(ISNUMBER([Phone Number]@row))), [Phone Number]@row < 1000000000, [Phone Number]@row > 9999999999, 1, "") Basically, I want a checkbox to tick if any of the following happens: Any characters are added It has fewer than 10…
-
Auto formula Sum is generating a 0 when no data is present yet
I have a column with an autogenerated formula looking at turnaround time. Essential day completion minus day start. Somethings are finished the day of and have a turnaround time of 0 days which is great for us, however, for rows that do not have a finish date yet it is auto generating a 0 instead of what should be a blank.…
-
I want a blank cell to return a symbol in another cell
This is a pretty basic question that I'm sure has been asked before, but I'm having trouble finding an answer. I'm using the below formula, but I need to add an additional rule so that if the Loaded cell is blank, it would return the "Hold" symbol. I've tried some variations of ISBLANK, but haven't gotten any to work yet.…
-
If Cell is Empty or Blank
Hi, I have created the following formula =IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Pending") > 0, "Pending", IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Created") > 0, "Pending", IF(COUNTIF([PCORI Reports]@row, "Requested"), "Pending", "Done"))) which is working efficiently, but…