Hi, I'm almost done with my app...I need a li...

(Joshua Rose) #1

Hi, I’m almost done with my app…I need a little input on a formula.

I need a formula where if a certain field is blank in the source spreadsheet and a different field is not blank in the source spreadsheet, then “XYZ” text displays in Appsheet.

Would I enter this under Data->Columns->Edit column definition–>Suggested_Values? And how would the formula be constructed?

Thanks much.

(Bellave Jayaram) #2

IFS(AND(ISBLANK( [ColA]), ISNOTBLANK ([ColB])), “XYZ”)

(Joshua Rose) #3

Thank you Bellave. This would go under App formula? When I enter it I get: Unable to find table ‘ISBLANK’.

(Bellave Jayaram) #4

In the app by clicking the pencil icon in your first screenshot

(Bellave Jayaram) #5

@Joshua_Rose I had missed the parens - fixed the formula above.

(Joshua Rose) #6

@Bellave_Jayaram Thank you, the expression is valid, however it is not returning XYZ in the app. The conditions are met. You can see on this screenshot the formula on the left, and on the app under Empty Trash Value $1.00 there should be another field for Empty Trash Earned / TBD.

(Joshua Rose) #7

@Joshua_Rose Here you can see on the source spreadsheet that Empty Trash Earned is blank and Empty Trash Time Approved is not blank.

(Joshua Rose) #8

@Bellave_Jayaram Hi, any thoughts most welcome!!

(Bellave Jayaram) #9

You need to open the row and save, only then the value will be written to the sheet. If you prefer to avoid opening the row, you can use Quickedit for any field and it will then sync and write the value.

(Joshua Rose) #10

@Bellave_Jayaram I’m sorry I don’t understand. Open the row where and save? Can you be specific, I’m confused…

(Bellave Jayaram) #11

I meant edit the row (if it already exists in the sheet) in a form view. If it is a new row you are adding then there’s no issue, it should be written.

(Joshua Rose) #12

@Bellave_Jayaram So I need to edit the row in addition to adding the formula to the column? Where do I edit the row?