Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Creating Formulas in Asta

3 replies [Last post]
Wed, 2010-05-12 07:53
Annette McElligott
User offline. Last seen 13 years 28 weeks ago. Offline
Joined: 12 May 2010
Posts: 20
Groups: None
Hi,

Does anyone have any experience creating and applying formulas in Asta Ver 11?

Specifically I am looking for information on how to create a formula that will search for a specific word within the notes of a task and then apply a traffic light system based on the number of times the word appears.

Thanks in advance for any help.

Annette
Top

Replies

Fri, 2012-02-24 11:03
#1
Daniel Townsend
User offline. Last seen 12 years 39 weeks ago. Offline
Joined: 26 Jan 2006
Posts: 3
Groups: None

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)

Top
Tue, 2010-05-18 09:15
#2
Andrew Willard
User offline. Last seen 12 years 19 weeks ago. Offline
Joined: 9 Dec 2009
Posts: 35
Groups: Board of Advisors, Building Information Modelling
Dear Annette,

Thank you for posting your question about the Formula’s.

I have read Mike Testro’s 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
Top
Wed, 2010-05-12 08:37
#3
Mike Testro
User offline. Last seen 35 weeks 6 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
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
Top