Skip to content
ProjectControls.com
Asta Powerproject

Creating Formulas in Asta

In the Open Standard
Annette McElligottMember for 16 years 5 months
Created
3
5
0
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
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Mike Testro ·
    #1
    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
    Report
  2. 0
    Andrew Willard ·
    #2
    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
    Report
  3. 0
    Daniel Townsend ·
    #3

    This 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)

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?