Formulas & Functions
Every formula and function has to start with this.
What is =
Logs new requests.
What is the Project Intake Sheet.
The foundation of all your work in Smartsheet.
What are Sheets.
For this view, you must have the start and end date of your tasks.
What is a Gantt chart.
Adds a series of numbers.
What is =SUM
All in-progress and completed projects including project plans, data and reports.
What is the Project Level Folder.
Compile information from multiple sheets and show only items that meet the criteria you specify.
What are Reports.
Enter a task duration of 0 and a start date.
What is a project milestone.
Evaluates a logical expression and returns one value when true or another when false.
What is =IF
When a project is approved and resourced, this is where it all starts.
What is the Project Template Medical Devices.
To gather and organize information within Smartsheet.
What are Forms.
Used to create a hierarchy on your sheet.
What are indenting rows.
Used in a Date column to return the current date.
What is =TODAY
Reports and Dashboards depend on this data.
What is the project plan.
To create a visual summary of sheet data.
What are Dashboards.
The longest distance between the start and the finish dates of your project.
What is the critical path.
Counts the number of cells within a range that meet a criterion.
What is =COUNTIF
Risk, Action, Issues and Decisions are documented here.
What is the RAID log.
Allows you to share Smartsheet files with stakeholders who aren’t Smartsheet users.
What are WorkApps.
Automatically aggregate project status and project health.
What are sheet summary fields and formulas.