Editing spreadsheet is fast and straightforward using DocHub. Skip installing software to your computer and make alterations with our drag and drop document editor in just a few fast steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and robust features that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and deliver records for completion to other people. All of this, combined with a competitive cost, makes DocHub the perfect decision to blot checkmark in spreadsheet files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the protection of your data, as we securely store 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