What is the syntax for empty status column - the gray default one ?
i tried this formula and it doesnt work -
IF({DOC TYPE}=“”,
“Missing DOC TYPE”,
“OK”)
Hello @NytaiK !
I believe you cannot check whether a file column is empty with a formula.
My suggestion is creating a status column named for example “Documents Provided?” with a default value of No.
In addition to that, create an automation as follows :
When column ( file column) changes, set “Documents Provided?” to Yes!
Essentially uploading a file to an empty column counts as a change, so this would likely be appropriate for your use case.
Hope this helps!
Giannis, Implementation Consultant at thespelas.com
I’m not trying to check if a file column is empty i’m trying to check if a status column is empty
Ah, I see. Just input a value like “Empty” in the default value and you should be okay 
IF({Status 3}="Empty","Empty","Not Empty")
1 Like
thanks very simple solution
1 Like