Hello, Good Morning.
I hit <error> cells whilst performing an operation that Involves
The <error> comes when the originated data column does not contain any String
I tried IF statement, but it gives me an argument error of mixing STRING with DATE.
The outcome I'd like to get to is - for any cells that doesn't have a DATE value, please leave it blank and do not perform the ASDATE or SHIFTTIMEZONE operation. I'd like an outcome that does not contain <error>.
Is this possible please? Thanks.
Please sign in to leave a comment.