Looking to automate your processes and save time managing your projects? The “Smartsheet: automate project management with formulas and functions” training course helps you master essential formulas and functions. You'll discover how to automate calculations, automatically update statuses, and extract key data easily, to improve the tracking of your budgets, schedules and resources. By configuring formulas and automations optimally, you'll be able to anticipate problems, better prioritize your tasks and improve collaboration within your teams.
Duration
0.5 day
Schedule
See training dates for details
Regular fee
$390
Preferential fee A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$350
Objectives of the training
By the end of the course, participants will be able to use formulas and functions in Smartsheet to automate data processing and calculate key process indicators.
Targeted audience
Anyone implementing tracking and collaboration tools in Smartsheet.
Simplified information sharing with interactive sheets
Quick access to key data facilitates decision-making
Course architecture
In this course, you'll learn how to use a wide variety of functions to automate calculations and synthesize key information from your processes and projects.
Understand the structure of a function in Smartsheet
Understand the similarities and differences with Microsoft Excel.
Browse the list of Smartsheet functions.
Use context-sensitive and online help to implement functions.
Implement functions in Smarsheet
Understand function arguments.
Mastering column formulas - Using the @row reference to automate calculations across an entire sheet.
Understand and debug errors.
Set up performance indicators by grouping information
Set up formulas on several sheets using references efficiently.
Use formulas in sheet summaries. Set up automated performance indicators.
Use advanced formulas
Use search formulas
Evaluate criteria using the @cell function
Use artificial intelligence (AI) to generate formulas
Use Smartsheet's function generation tool (Enterprise version).
Use ChatGPT (or another tool) to generate functions in Smartsheet.
If you have any questions about registration, cancellation, schedules, language of instruction, etc. you will find answers in our FAQ.
Pedagogical details
Training architecture
Interactive lectures, practical exercises in Smartsheet and tip sheets
Type of training
Skill development
Skill development and knowledge integration
Decision support
Basic knowledge
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Preferential fee A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$350
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
By checking this box, I confirm that I have read and agree toTechnologia’s Privacy Policywhich provides information on how my personal information will be used following collection. In the event that you do not consent to the terms of the concerned Privacy Policy, Technologia will not have the information to assess your request, contact you to follow up on your request or provide you with the services.
I would like Technologia to send me commercial communications.
Learn more >
By checking this box, I agree that Technologia may use my personal information to send me commercial communications. I understand that I can withdraw my consent at any time by clicking on the unsubscribe link included in each communication. To learn more about how we manage your personal information, please consult our
Technologia’s Privacy Policy.