Tuesday, August 6, 2013

Google Spreadshet to Type Checkmark

Question:

How to put a check mark in a Google Spreadsheet?

Solution:

Copy the following character and paste it in any cell of your spreadsheet:


And you can also get this character by using script, have a look at the following screenshot:


I have the following formula in Cell A1:
=checkmark()

the above formula is a custom function checkmark() that I have written and inserted in Script.

Have a look at the following code:

///////////////////////////////////////

function checkmark() {
  return '\u2714';

};

///////////////////////////////////////

put the above code in your script editor, and then you can use it directly in your Google Spreadsheet or you can use its functionality in the Google Apps Script.

Let's have one more example, have a look at the following screenshot:


I have the following formula in Cell C1:
=if(A1>B1;checkmark();"X")

Or you can also have the following formula (without using any script):
=if(A1>B1;"✔";"X")

And If you are not much familiar with scripts then check out the following link:
http://igoogledrive.blogspot.com/2012/08/how-to-write-script-in-google.html 

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.


I also take up private and confidential projects:
If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

No comments:

Post a Comment