This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
Daryl_Zernick
Bronze 5
Bronze 5
Since ‎03-15-2019
3 weeks ago

My Stats

  • 64 Posts
  • 0 Solutions
  • 19 Likes given
  • 9 Likes received

Daryl_Zernick's Bio

Badges Daryl_Zernick Earned

View all badges

Recent Activity

Sort not working

01-25-2024
I am using the following "Valid If" formula:SORT(Form Responses 1[Email Address]+StateOfMichiganCompleted[Email Address], False)The drop down does not sort the combined list, only each tables list then combines the two lists into one so that you have...

While editing a record, check to see if an email is in another sheet

01-23-2024
Hello,While entering a new record or editing an old one, I want AppSheet to tell me if an email exists in another sheet. Below is what I thought would work, but it doesn't seem to be checking as emails I have entered are in the other sheet.IN(UPPER(I...

How can I get this value?

05-11-2022
Is there an expression that can be written to get this number? I am trying to get an Action to fire if this number is "0", writing the expression into the "Only if this condition is true" option.Any help is much appreciated!!!!Daryl

Show "Add" if ID is not already in table

05-10-2022
I have two tables linked together by unique ID numbers in an ID column in both tables. One is a top level "Employees" table and the other is a table acting as a database for various dates stored in one row for each linked ID called "Updates." I do no...

Update table 1 column with the changes made to referenced table 2

04-27-2022
Hello,It's a simple task, but I am just stuck on writing the proper expression.I have two tables in one Google Sheet, referenced together with unique "ID"s. I am using one, "EEs", as an employee record and the other, "History", to record the historic...
View more