Apply Different Formulas to Parent and Child Rows Automatically | Smartsheet Tutorial скачать в хорошем качестве

Apply Different Formulas to Parent and Child Rows Automatically | Smartsheet Tutorial

In this video, Dan from School of Sheets shows us how to set up a single column formula that returns a different result for a parent row than it does for the accompanying child rows. He also shows us a work around to apply different cell formats to the parent row vs. the child rows in a single column. 🏢 ABOUT SCHOOL OF SHEETS ➔ We are a bespoke consulting firm specializing in developing custom Smartsheet Solutions ➔ We are a Smartsheet Aligned Gold partner with a team of certified consultants and software developers. ➔ We work with businesses of all sizes and industries. ➔ Learn more at http://www.schoolofsheets.com 🤝 WANT TO WORK WITH US? Fill out our new client interest form at https://www.schoolofsheets.com/WorkWi... 📚 KEY RESOURCES ➔ Try Smartsheet free for 30-days http://www.schoolofsheets.com/TrySmar... 🔔 SUBSCRIBE FOR MORE GREAT CONTENT 👉    / @schoolofsheets   ⌚ TIMESTAMPS 00:00 – Intro 00:09 – Question from the Smartsheet Community 00:50 – Objectives 01:02 – Part 1: Write and IF() Formula to Score Child Rows 02:20 – Part 2: Write a Formula to Score Parent Rows Based on the Values in the Their Child Rows 04:12 – Part 3: Combining the Child and Parent Formulas into a Single Formula 07:23 – Part 4: Different Cell Formats in a Single Column 10:20 – Recap 11:12 – Final Thoughts #smartsheet #formula #hierarchy #conditionalformatting