Custom Status Column Update based on Tasks complete
My project sheet is very granular. I run 50+ sheets simultaneously, and have a metadata sheet with all key information linked for at a glance progress updates for the various milestones for each project.
To give further detail on the at a glance page, I would like to give a "status" update for each parent status cell. This will require an individual formula for each unique phase of the project, but I don't know what the formula should look like. Below is what I would like the status to look like.
For the 50% LV Status cell, I would like it to update based on what is marked complete, with what step is in progress.
For example, if Line 51 status is marked complete, the parent row, line 50 would update to Received; When line 52 (and 51) is marked complete, status for row 50 would change to Distributed; Line 53 is complete, (and 51, 52) Line 50 status updates to Reviewed; line 54 would change line 50 to Sent for Approval, line 55 would change line 50 to Approved, line 56 would change line 50 to Call scheduled. When all status's are marked complete, the Status in line 50 would change to COMPLETE
Is this even possible. Relatively new to Smartsheet, but I think if I had a template formula, I could duplicate it for each unique set of tasks. Then save my template for all future projects (that run off the same sheet template)
Help Article Resources
Check out the Formula Handbook template!