Results 1 to 7 of 7

cascading dropdown with 2 values to prepopulate (also in Quip)

Threaded View

  1. #1
    Registered User
    Join Date
    10-18-2022
    Location
    Berlin
    MS-Off Ver
    2019
    Posts
    5

    Question cascading dropdown with 2 values to prepopulate (also in Quip)

    Hi all,

    My name is Monika from Germany. I am hoping someone can help with a formula and possibly with Quip conversion.

    I have created a cascading dropdown in Excel on sheet Selection. It reads from sheet DD. I have 2 issues:

    1) On two occasions, there is only one sub-selection possible, so I would like to adjust the formula, that if the selection is made, it prepopulates the corresponding value in column M, i.e., when "N/A (comment)" is selected in column L, "N/A (comment)" is automatically filled in in column M. I tried a bunch of IFS and IF(ANDs but everything fails.

    2) When it works, is there a way to put that into a Quip? The formula that works in Excel, isn't recognized in Quip. Maybe other functions would accomplish that? Quip seems very limited.

    Any help would be much appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. having a 2nd and 3rd cascading dropdown list off a first dropdown
    By lee-a-michael in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-08-2021, 09:33 PM
  2. [SOLVED] Dropdown box cascading selections
    By Roadrun030 in forum Excel General
    Replies: 2
    Last Post: 10-01-2019, 09:58 AM
  3. Prepopulate using dropdown box and vlookup assistance required plz
    By ladylulu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-29-2018, 09:16 AM
  4. Cascading Dropdown for A Calendar
    By pspunlimited in forum Excel General
    Replies: 17
    Last Post: 02-05-2015, 03:44 AM
  5. Cascading values depending on dropdown selection
    By SteveMorrisUK in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 04-27-2013, 06:26 PM
  6. [SOLVED] Cascading dropdown lists all tied to first dropdown
    By ruthl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2012, 08:03 PM
  7. [SOLVED] Cascading Dynamic Dropdown Lists
    By choop in forum Excel General
    Replies: 4
    Last Post: 06-14-2006, 12:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1