Using an IF Statement to Identify Dates from the Previous Month | Smartsheet Tutorial скачать в хорошем качестве

Using an IF Statement to Identify Dates from the Previous Month | Smartsheet Tutorial

In this video a Smartsheet Community User wants to identify when a date is in the previous month. Join Dan from School of Sheets as he sets up an example sheet and generates a formula that will do just that. 💻 FUNCTIONS USED ➣ IF() ➣ MONTH() ➣ TODAY() 🏢 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:22 – Question from the Smartsheet Community Thread 00:52 – Setting Up the Example Sheet 01:45 – Setting Up the Formula 03:46 – Alternate Solution Using a Checkbox 04:21 – Adding Some Conditional Formatting #smartsheet #formula #automation #projectmanagement #ifstatement