"format" true/false to something like "yes/no" in Google Sheets
Note that I'm only looking to "format" the info.
Background: we have a Google Sheet that downloads raw info from a BigQuery table. One of the fields is Boolean so the results show "true"/"false".
We have another tab on that GS that does a query. For display purposes, we'd like to show something like "Y/N" or maybe even "X""(blank)" instead of "True/False. We could create like a helper column on the tab that contains the BigQuery info to change true/false to what we want, and then query off of that, but the raw data is already pretty big and we'd prefer not to keep adding more columns if we can help it.
Here's a sample GS
Is there some way to do this?
Solution
try:
=INDEX(IF(A1:A=""; "X"; IF(A1:A=TRUE; "Y"; "N")))
- how to get a loop iteration number as value in google apps script?
- Google Sheets - replace the exact text/number with a different one ignoring other matching parts
- "format" true/false to something like "yes/no" in Google Sheets
- How to count number of non-blank cells (cells that contain text)?
- Sort Sheet Range in Natural Order
- Which would be the most time efficient way to replicate a formula through N cells
- Why has my onEdit Script stopped triggering?
- How do I get the column letter of a single row where a particular value equals a test value?
- Google Sheets: Return latest date from one column depending on variables in 4 other columns
- "In ARRAY_LITERAL, an Array Literal was missing values for one or more rows." error with stacked queries when any of the results is empty
- How do I do a multi-lookup and concatenate results in google sheets
- How to Calculate Accumulated Investment with Interest and Expenses in Google Sheets? (with arrayformulas)
- When a cell changes, copy a range
- Embedding multiple arrays inside another array at various points according to a true/false condition
- How to refresh random JS variables in Google Sheets
- Select column minus header (or deselect cell)
- Remove trailing ".00" from numbers in Google Sheets
- Google Apps Script fails to retrieve sheet by name
- Get the last non-empty cell in a column in Google Sheets
- SUMIFS with multiple criteria and different ranges
- Countif with case sensitive google-sheets
- How to check for duplicate values in column A across two sheets?
- google sheets query left join one-to-many
- Using Google Sheets to calculate electricity bill with Different Tariff
- How can I skip a specific column when copying from another sheet (setValues)?
- Google Spreadsheet - Round down at 0.5, but round up above that
- How do I locate a Google SpreadSheet ID?
- Google sheets script exceeds "maximum execution time" in ONE account
- How can I reference range on another sheet within a Google Sheet for conditional formatting?
- Script to convert .XLSX to Google Sheet and move converted file