-
Multiple currency columns thousands separators
We have a sheet with multiple currency columns, EUR, GBP, AUD etc. Is there a way to define thousands markers? Currently it seems to be defined by user account setting, which does not work for us as we need EUR with "dot" separators and AUD with comma separators.
-
Changing column to a "List"
I have a column that has equipment in it, it is set up as a text column. I am using the information in that column for conditional formating. Now I want to make that column a list to choose from and I can't because of the conditional formating. Do I have to un-do all the conditional formating to change it to a list column…
-
If and checkbox
I have used th IF equation and the checkbox and I want it to copy a value from another cell when the checkbox is checked. Until here I am ok. However I want it to apply the number "0" (zero) when the check box is unchecked. can anybody help me please? Thank you.
-
% complete value not adjusting start date of next task
Hello I am hoping someone can help please, here is my problem I have a few tasks, dependent on each other - D is dependent on C, C is dependent on B, B is dependent on A etc etc. I have a complete tick box for them and also a % complete column Task A is complete, Task B is 40% complete, Task C is still showing it starting…
-
Very strange formatting issue
In my sheet, I keep my primary column font color "Red" until we take the first action. At that time I manually change the color to "Black". I do not have any conditional formatting that has any control over that column. I do have other columns that do have conditional formatting controlling them. Here is the strange part..…
-
Clear Cells if Time Is
Hi, I'm looking for a formula to clear the contents of a column daily (preferably at a specfiic time). To give you an idea of what it is being used for; My sheet has a list of contacts and a yes or no checkbox column. Every day at a certain time an update request is sent out to all contacts listed asking "will you be…
-
Locking a row when a check box is selected
Is it possible to have a row "lock" when someone selects the "check box" column, so they (Editors) can not change data on that row?
-
Dates not lining up
My editorail calendar isn't lining up when I sort by date. My April dates are below July. I'm not sure what's happening with the formatting.
-
Conditional Formatting based on a cell text formatting
Hello hive mind. I am familiar with IF statements and Conditional Formatting, but I am not seeing a way with either of those for the followng. I would like to set a Conditional Formatting Rule to highlight a row to a certain color if the text in a particular cell is in bold. There does not seem to be a way with Cond. Form.…
-
Create report based on a conditional format in sheet
We are trying to build a report that looks at the format of a cell in the main sheet. We are using the conditional formatting option to set a specific cell's format based on the combination of various other fields in that row. Now that the sheet is correct, we are going to the report builder to create a report that looks…
