IF ISNOTBLANK() Expression

[alhazen]

Dear All,

Need your help!

I have two column which are [report] as file type column and [status] as text type column. I put this expression in [status] column:

IF(ISNOTBLANK([report]),"Closed","Pending") 

So when users have uploaded the file, [status] column will change to "closed". But My formula it doesn't work.

Thank you.

[1minManager]

Is this an app formula or virtual column?

[alhazen]

Hey, thank you for responding. This is an app formula. Any suggestion?

[gregdiana1]

I have tested this and it works fine.

When no files are present it shows

So STATUS is Pending as no files exist and it awaiting file upload and save.

As soon as I upload file it shows STATUS is closed

The spreadsheet before save is 

and after saving it is 

So all appears ok.

However, only Closed will physically appear in the spreadsheet after saving and Pending will only appear at entry time and as such is redundant unless you want to test whether the same file has been entered previously.

As such you need to clarify what you mean by it not working as expected. What are you expecting?

[alhazen]

Sorry, i put the formula in Initial Value field.

I used behavior action with this formula to upload file:

INPUT("report","")

 Is this why my IF(ISNOTBLANK()) formula is not working?

[Steve]

The value of the report column isn't populated for several seconds after the form is submitted. It takes some time for the file upload to occur and for the AppSheet server to update the data source.

[alhazen]

Thank you @Steve for your explaination.