-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Is there a way to copy a sheet's conditional formatting rules to use on another sheet?
I would like all of my sheets to have consistent formatting,
-
Tracking resources, their hours per task and their hourly rate
Using a standard project template, is there a way to track resources (licensed and non-licensed), their hours per task and their hourly rate. This way I can calculate their total hours worked x rate to get their cost.
-
Conditional Formatting - Target Dates vs Actual Dates
Hey guys & gals Basically I'm trying to get my actual task finish date to highlight green or red if it hits or doesn't hit the target date. I know I need a checkbox column to do this. I've added one with the following formula =IF(Finish2 > Baseline2, 1, 1) Finish2 = the first cell with the actual finish date Baseline2 =…
-
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…