Questions tagged [google-sheets-cell-format]

Use for questions about Google Sheets cell format like formatting numbers, dates or using the equal, plus, minus symbols as part of texts (strings)

14 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
21 views

How can I add a thick borderline after a certain text in Google Sheets?

I'm trying to modify my Working Hours Spreadsheet; What I want to do is add a thick borderline after each Sunday, so I can better identify each individual Week of the Month. Here's the Masterfile ...
1
vote
0answers
2k views

Google Sheets text wrap no longer expands cell

All of a sudden I seem to be having trouble in my Google Sheets auto extending height of cell with text wrap, for certain cells. Mac OS: 10.13.6 (17G65) Chrome: Version 73.0.3683.103 (Official Build)...
1
vote
1answer
2k views

How to calculate time worked in Google Sheets after 12am?

I usually work from 3pm to 1am. I can't seem to find out how to make google sheets find the correct duration between those times. I know the correct duration is 10 hours, but no matter what I do ...
0
votes
1answer
14 views

Create a RAG system based on dates, upcoming and expired within Google Sheets

I want to create a RAG system in google sheets based on dates in a cell. Column A will show a date when someone is trained on a topic and column B shows the due refresher date (3 years later). I want ...
0
votes
0answers
18 views

How to increase precision up to 18 decimals after decimal point in Google Sheets?

I want to have a number like this in my cell, 18 decimals after decimal point: 10.643958132611619777 But Google Sheets rounds it down to 13 decimals 10.6439581326116 How can I increase precision ...
0
votes
0answers
23 views

Use an embedded image as a link in a Google Spreadsheet in the published version

This is a very specific set of circumstances. I'm trying to use an image which I've embedded as a link. This works in the Edit interface, but when published, the image/cell does not act as a link. I'm ...
0
votes
0answers
13 views

In a sheet which has tab names as date, can I empirically refer previous sheet, so I can calculate report based on yesterdays

In a sheet which has tab names as date ., can I empirically refer previous sheet, so I can calculate report based on yesterdays? =IMPORTRANGE("Link",""&BM4&"!AU:BC&...
0
votes
1answer
31 views

IF/AND functions from multiple cells

Would anyone know how to fix this problem? I want cell A676 to categorize based on info from 2 cells C676 and D676. Basically IF the word "Paypal" is in cell D, AND there is a specific ...
0
votes
0answers
13 views

Protect or Lock Particular Columns Formatting in Google Sheet

I have a file where we want to lock or protect multiple columns formatting to "PLAIN TEXT" . So if users copy and paste or paste as values should not alter the formats?
0
votes
1answer
27 views

Google sheet - highlihghting cell if in the same row other cell not empty

I'm trying to make a worksheet where I log shift hours. I made columns with dates and to each date a row of hours I want the date text to be green if in the same row a cell is not empty.. The code I ...
0
votes
1answer
201 views

Show insignificant zero

I want, when I write a Number in a Cell, that the zeros are still visible. In a Google sheet. e.g. when I write 1.050, or 1.0 or 1.2000 there should stay exactly that. Not 1.05; 1; 1.2 or something ...
0
votes
1answer
74 views

Line spacing in Google Sheets

Is there a way to increase the line spacing in Google Sheets, not the cell padding? I'm referring to the space between the lines in a paragraph that's inside a cell. If not, is there an addon that can ...
-1
votes
1answer
13 views

How can I search an argument in GSheets to return TRUE if the argument references another cell?

Hello! In some cells in the True Price Column, I applied a discount by referencing the cell Conv!C2. For example, the argument in D13 is =MROUND((D8 * 2) * Conv!C2, 5) where (D8 * 2) is me calculating ...
-1
votes
1answer
1k views

How to format a negative number red within a mixed formula result

We use the following formula: ="Stu/W: " & TEXT((A$2/B2),"[Red]#,###,##0.00") &"€" and wish to have the resulting negative currency numbers colored red and positive blue. Unfortunately ...