Help on formula: How to copy adjacent text using a specific text from a different column
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
Comments
-
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
-
Hi Chris,
Yes, I do want to display the text from the Progress column that has the status "Active".
Kind regards,
Grace
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!