Tony Coleman’s Profile

Community member since June 2016



Good Day All:


I am trying to create the following Formula however I am receiving an  Incorrect Argument:

If impact is High and Influence is High, then the Classification is Key Player

My Formula: =IF(AND([Impact on Project]2 = "High", [Project Influence]2, "High", ="Key Player"))


All help


Hi all,

I need some help...

Whilst I am of the understanding that you can set up notifications when a user makes any changes to a sheet, is there any way you can be notified if someone has in fact opened a sheet they have been invited to view?

Thanks in



My sheet 1 has a structure with column 1, 2, and 3.

My sheet 2 has a structure with the same columns as sheet 1 - column 1, 2, and 3 - plus new columns column 4 and 5.

Based on values in column 2 in sheet 1, I would like to export the row in sheet 1 that satisfies a condition, to sheet 2.  Once