Help on formula: How to copy adjacent text using a specific text from a different column

Grace

Hi all,

Please need help on formula. The example image below is a project with sub tasks and I wanted to create a formula in the Progress column highlighted in yellow (this is the main header).

The condition is: if the status of the row is "Active", then show me what is its current Progress.

Based on the screenshot below, the expected result should show "Delayed" in the yellow cell.

Many thanks in advance for the help,

Grace

Chris McKay

Hi Grace,

=IF([Status]1 = "Active", "Delayed", "") will do what you're asking, but I don't think that's what you want to do. Are you literally just wanting to display a certain text string (e.g. "Delayed") when another column is set to a particular status (e.g. "Active")?

Kind regards,

Chris McKay

Grace

Hi Chris,

Yes, I do want to display the text from the Progress column that has the status "Active".

Kind regards,

Grace