Combining Formulas in 1 Cell
Hello,
I have a column with this formula: =PARENT([Task Name]@row) which is assigning my rows the name of the parent so I can create swimlanes in the card view sorting my tasks by the parent project name.
In the same column I would like to also have an option to override the first formula with this formula: =IF(Status1="Complete", "Complete"). I'm using that formula to override the parent project name so I can create a swimlane with all the Completed tasks.
Question1: If I want to use both formulas in the same Task Name cell, how do I combine them?
Question 2: Is this the best way to accomplish being able to have card view swimlanes for the parent project along with a "Complete" swimlane that ensures only "Not Started" and "In Progress" tasks are left in the project swimlanes and completed items are lumped into one lane?
Thanks!
Answers
-
Try something like this...
=IF(Status1="Complete", "Complete", PARENT([Task Name]@row))
-
Thanks Paul. Unfortunately, it didn't work. Even though the Status was changed to "Complete" the Project Name still showed as the parent row task name. It didn't update to "Complete" for the project name.
Any other ideas? Is there another way to accomplish the goal I'm trying to get to?
-
Lets try making sure we are referencing the same row in both cell references...
=IF(Status@row="Complete", "Complete", PARENT([Task Name]@row))
-
It worked! Thank you so much.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!