Editing ANS is fast and straightforward using DocHub. Skip installing software to your laptop or computer and make changes using our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its convenience and powerful capabilities that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and send documents for completion to other people. All of this, combined with a competitive cost, makes DocHub the ideal option to blot out checkmark in ANS files with ease.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the safety of your data, as we securely keep them in the DocHub cloud.
to display check mark against the completed tasks and cross against pending tasks in the formula bar equal if function open parenthesis select the cell containing status of work equal double quotes done double quotes comma qr function open parenthesis 252 close parenthesis comma curve function open parenthesis 2 5 1 close parenthesis once again close parenthesis enter copy the formula under the cells below click on font select windings