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.
Whenever new material comes in, my google sheet column get updated but
the same value is not reflecting in appsheet “Enum”. Every time, i need
to regenerate the column to get the new values. How to make appsheet get
the latest “enum” values from shee...
Hello, I am trying to make reference column as required but i am not
getting the enable option for rest of 3 columns. Any reason why i got
enable option for 1 column & why not for rest of 3 columns? Attached the
screenshot FYR.
I’m not sure why, but my array formula is not working in google sheet
and even when it’s working, it doesn’t extend the formula down to
through the rest of the column’s cells. Where have I gone wrong?
=ARRAYFORMULA(LOOKUP(2,1/($J:$J=$J87),$S:$S))
I would like to set the different initial value for the form based on
dropdown value(Enum). I got the formula right. Ref the screenshot:
image|690x387 but its not working in the app. Please someone help me on
this.