Solved: If Blank then - Page 2

Lee_Yanez · 05-26-2020 05:41 PM

Hello,

A little help would be appreciated

I have two columns. Col1- ‘Do you wish to leave a comment’ & Col2-‘Comment’ - The first is a yes/no. The second is a long text.

I’ve been unsuccessfully trying to create a scenario where if Col1 = “No” then Col2 is auto filled with text “No comment”.

And if Col1 = text “Yes”, then the user is allowed to leave a long text comment.

Can someone show how to achieve this please.

Suvrutt_Gurjar

Please explore if following helps you.

In the Col2 , initial value setting , you could have an expression such as

IFS([Col1]=FALSE,“No Comment”)

In Col2, Editable ? Setting, you could have

[Col1]=TRUE

In Col2 's Reset on Edit? setting you could have

[Col1]=FALSE

Here Col1 is assumed to be AppSheet’s Y/N type column , so it evaluates to TRUE or FALSE based on enum selection. So TRUE and FALSE are used in expressions above.

View solution in original post