Thank you for posting your question about the Formulas.
I have read Mike Testros response to you and he is correct. Unfortunately you can not create the type of formula you want within Powerproject at the moment.
The columns in Powerproject work exactly as a spreadsheet.
So if the formula works in excell then it can be re created in PowerProject.
=Find(text,cell,position) will show you where the word appears in the string but I know of no formula that will count the number of times it appears in the cell.
If you have a full support licence I suggest you contact the Asta help desk by email and they will give you a quick response.
Member for
19 years 9 monthsThis formula will look for a
This formula will look for a specific word (issue in this example) and give you a high priority traffic light.
Dont know how you'd count the number of times a word appears
A traffic light indicator to highlight any tasks whose notes contain the word issue.
Formula
If(Search("Issue",Notes)>0,High,None)
Member for
15 years 11 monthsRE: Creating Formulas in Asta
Dear Annette,
Thank you for posting your question about the Formulas.
I have read Mike Testros response to you and he is correct. Unfortunately you can not create the type of formula you want within Powerproject at the moment.
We will add this to our wishlist.
Regards
Andrew Willard
Member for
19 years 10 monthsRE: Creating Formulas in Asta
Hi Annette
The columns in Powerproject work exactly as a spreadsheet.
So if the formula works in excell then it can be re created in PowerProject.
=Find(text,cell,position) will show you where the word appears in the string but I know of no formula that will count the number of times it appears in the cell.
If you have a full support licence I suggest you contact the Asta help desk by email and they will give you a quick response.
Best regards
Mike Testro