Hi All,
How can i apply different formula basing on cell value?
For instance
i have a columns
Type, Duration, Original
If type = "Sub-Task" I need formula for Original "= Duration*1440"
If type = "Story " I need formula for Original "=SUM(CHILDREN())"
i tried
IF(Type = "Sub-Task" , "=Duration*1440", "=SUM(CHILDREN())")
but that doesnt work.
thanks