-
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,…
-
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.…