Can I use 2 formulas in 1 cell/column?

Options

Hello! I'm stuck trying to put to formulas into one column. Here's the scenario.

I have multiple projects with multiple subtasks.

When the Status column is updated to "Completed" I would like the Progress column to update to 100%.

I've successfully completed this step with the formula:

=IF(Status1 = "Completed", "100%") in the Progress column.

Now, I'd like the average % of the completed subtasks to display in the parent row in the Progress column.

So, if I I have Parent Task 1 with 4 Subtasks, and 2 are moved to Completed, those 2 subtasks should have 100% in the Progress column and the Parent Task should have 50% in the Progress column.

Is this possible?


This is ideally how I'd like it to look.


Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!