if formula

Sue van Niekerk

HI Guys

Looking for 3 formulas ( cant get mine to work)

1st one -- when status is Closed RYG must be green - when status in open must be red and when pending must be orange

2nd one

when "action Required" is blank status must be "No Action Required" when Action Required is not blank then

Status should say "Action Required" SECOND PART of the formula - when Action Taken is not blank the status should say "closed"

Mark Cronk

Hi,

Try:

For RYG:

=IF(status@row="closed", "green", IF(staus@row="open", "red", "orange"))

For Status:

=IF(ISBLANK([action required]@row), "No Action Required", IF(NOT(ISBLANK([action taken]@row)), "Closed", "Open"))

Mark

Mark Cronk

Hi Sue, Get it to work? Thank you for contributing to the community.

Mark

Mark Cronk

Hi,

Try:

For RYG:

=IF(status@row="closed", "green", IF(staus@row="open", "red", "orange"))

For Status:

=IF(ISBLANK([action required]@row), "No Action Required", IF(NOT(ISBLANK([action taken]@row)), "Closed", "Open"))

Mark

Sue van Niekerk

Thanks Mark

Got the first one working battling with second one - but will rethink it for a bit :-)

Mark Cronk

Hi Sue, Get it to work? Thank you for contributing to the community.

Mark

Sue van Niekerk

Hi Mark -

Yes got both working :-)

Thank you so much

Sue

Mark Cronk

Prefect. Thank you for the vote up.

Mark