-
Help with Status and Date Columns
Hello, I am having trouble with a formula. I have 3 date columns, and 1 status column. I would like the status to change with the input of a date in the columns. Here is the reasoning for the question. I have "Ready Date", A "Start Date", and a "Complete Date". When a date is in the "Ready Date" column, I want the status…
-
Count number of cells containing specific text
Hi, I need to count the number of cells that contains a part of a text. Is there any wildcart symbol I could use? for example abcd abfd abpd jged In this case I need a formule that count the cells with the text starting with the letters ab. /Michelangelo
-
Can the SumIF check against multiple values instead of one?
I need to sum up a column if the value of another column is equal to EITHER X or Y. I was able to write the formula to check against 1 value but I want it check against mutliple values. =SUMIF([Hours]1:[Hours]10, Org104:Org110, "X") I want it to become : =SUMIF([Hours]1:[Hours]10, Org104:Org110, "{X", "Y"}) Is this…
-
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 =…
-
Limitations on design - Can I put a forumula in a cell in a date column
Only a couple of days into the trial and I was looking at creating some KPI's for a Sight. Based on what I'm seeing, the underlying calculation MUST exist on a sheet somewhere to be pulled into a sight. The problem I run into is if on a sheet a column is a date or drop down etc. and I want to use a cell in that column in a…
-
Why can't I see zeroes?
I've got a long formula that determines an IP address for a computer. That formula should result in a formula for an IP address that looks like this: 10.20.12.32 However, when there's a zero entry, SmartSheet is omitting the zero, so the result looks like this: 10..12.32 I need to show the zero! If I type a zero in a…
-
How do I convert Text (from a count) to a number?
Figured out how to use the COUNTIF to get a count within a column if a box is checked it contains a certain text in a dropdown, by changing the results to text (e.g., ...+""). However, what appear to be numbers are acutally text and I cannot sum them. Any suggestions how to convert? Thanks
-
time based reports?
I'm sure what I'm looking to do is not that difficult, I just can't find a way to achieve it. What I have is a sheet that consists of quote amounts ($) that are relative to a quote date. What I want to do is to look at how many dollars we have quoted that are on quotes a month old, 2 months old, etc. Ideally this would be…
-
RYG(B) Balls - How do I reference the value of child cells belonging to neighboring cell/column?
=IF(children([Finding Status]11)="Closed", "Blue", "Yellow") The above attempt is failing me (i.e., "missing or invalid parameters"). Any advice? Thanks! John
