ReallyTrying
02-16-2007, 08:54 AM
Hi,
I am quite perplexed with this issue.
I have created a formula to return the number of projects within a specific stage. the formula is as follows
=concatenate("Status (stage): ",Subtotal(3,stage))
The stage is a defined name that runs past the length of the actual firelds of data I planning for the future projects upcoming projects.
The formula will not display the correct number within a given stage nor will it display the text Status (stage): nn
When I use the function arguments the formula results are what I expected. Status (stage):211.
So my issue is that the results will not display properly within the cell not matter what filter is applied.
: pray2:
I am quite perplexed with this issue.
I have created a formula to return the number of projects within a specific stage. the formula is as follows
=concatenate("Status (stage): ",Subtotal(3,stage))
The stage is a defined name that runs past the length of the actual firelds of data I planning for the future projects upcoming projects.
The formula will not display the correct number within a given stage nor will it display the text Status (stage): nn
When I use the function arguments the formula results are what I expected. Status (stage):211.
So my issue is that the results will not display properly within the cell not matter what filter is applied.
: pray2: