Tables: Fill in the Blank fields can't be used on Advanced Formula

  • Profile Image
    wneater
    Asked on February 05, 2021 at 02:09 PM

    Having trouble translating FITB fields to formulas. I have two FITB questions (single choice and dropdown - so, fixed possibilities) which translate to the submissions table, but, when I try to use that data in a formula it doesn't show up as a possibility, even when I expand the column.

    Ultimately, what I want is to install what essentially would be "if" statements, i.e. if

    date = 2/6 and time = 12P a different column would show "s1"

    2/6, 4P = s2

    2/7, 12P = u1

    2/7, 4P = u2

    I feel like I can figure some of this out if i was able to use the data from the FITB question. Please assist!


  • Profile Image
    EltonCris
    Answered on February 05, 2021 at 05:22 PM

    Let me escalate that as a feature request so hopefully, that will be considered in the future updates. I can also replicate it in the cloned form too, the Fill in the Blank Fields can't be used in the Advanced Formula. We'll update you here once this is implemented.

    02062021_1Mxn0MlDnG.png