Created
May 23, 2019 08:49
-
-
Save abhitechno01/e53d9f392eed7d9443d46fd7596e68f9 to your computer and use it in GitHub Desktop.
Google sheet tips
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ###################################### | |
| Conditional Formatting | |
| Generic status used by developer | |
| ###################################### | |
| Open,Completed,Resolved,WIP,Issue,UIPending,Need Discussion,Won't Fix,Duplicate,Invalid | |
| ######################################### | |
| Split a cell horzonallty or diagonally | |
| ######################################### | |
| ="OneThing " &char(8594) &char(10) &char(8213) &char(8213) &char(8213) &char(8213) &char(8213) &char(8213) &char(8213) &char(10)&"Second Thing "&char(8595) | |
| Explanation: | |
| CHAR(10) adds a line break. | |
| CHAR(8213) adds a horizontal bar. | |
| CHAR(8594) gives a right arrow. | |
| CHAR(8595) gives a down arrow. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment