In this video we walk through the use case for updating large nested if formulas in a sheet using a substitute formula. This is especially useful when you are building a large sheet that have the same fields for numerous instances. For example an estimating sheet where you have 30 or more products that require the same inputs.
- Smartsheet - Substitute formula for updating nested IF formulas when building pricing solutions. ( Download)
- Smartsheet Nested Substitute Functions: Formatting Phone Numbers and Strings ( Download)
- Game Changer Formula In Smartsheet ( Download)
- How to use INDEX MATCH Formulas (And Why They’re Superior to VLOOKUP) – Smartsheet ( Download)
- Smartsheet INDEX COLLECT Formulas ( Download)
- Formula Writing in Smartsheet ( Download)
- How To Integrate Smartsheet With Excel - All You Need To Do. ( Download)
- Maximize Results with Smartsheet Workflows-Semiconductor Edition ( Download)
- The Excel FORECAST Function ( Download)
- How to Automatically Copy a Range of Data in Excel ( Download)
- What Your Boss Can TRACK About YOU with Microsoft Teams ( Download)
- Copy Filtered Data to Another Worksheet in Excel With This Tip ( Download)
- Smartsheet Engage Highlights from 2024 User Conference : Recap Feature Announcements by Echolocity ( Download)
- What is Smartsheet A good look inside! ( Download)
- Smartsheet demo using Data Shuttle demo to update dropdowns automatically ( Download)
