-
Nested If or Ifs
Hello, I have one cell with two pieces of data separated by a / but not all cells have two two data points. I have a formula to separate out the data to the left and right of the / when there are two pieces of data, but am struggling to find a way around the error of "Invalid Value" when there is only one piece of data in…
-
Date and Balance Formula
Hi there, I need help creating 2 formulas I am trying to create a formula that takes into account if the Week Ending is a specific date than the balance for that week ending displays accurately. The second formula would essentially be the same if the Week Ending is a specific date what are the number of hours being…
-
How to combine if/or statements
Hi, I am trying to create a formula so that if days open is >=4 color turns red, if days open is >=2 color turns yellow or color is otherwise green OR if the resolved column is check the color is green I am trying to combine the below two formulas but can not seem to get it right. =IF([Days Open]@row >= 4, "Red", IF([Days…
-
Display a calculated, non-editable value on a form based on form values
Is there capability to display a calculated, non-editable value in a form? The previous fields are inputs to a conditional formula and I would like to display the results within the form if possible but I can't seem to find a way to do that. Thanks, in advance! Mark
-
Expressions in Data Uploader
I have a Workflow template and a few expressions someone created before me. My goal is to have a sheet that is manually populated and then we drop in a .csv file every so often and it updates the Status field and the Account Balance field. Pretty much everything works except for the Status field needs to be updated…
-
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,…