Question

Auto-fill is automatically applied by Smartsheet within every sheet. Which two of the following functions does auto-fill perform?

a) Copy manual update requests to generate recurring updates
b) Continue patterns of formatting
c) Apply formulas and adjust cell references to adjacent rows
d) Generate a numeric value based on conditional formatting rules

Answer 1

In Smartsheet, auto-fill can continue patterns of formatting and apply formulas while adjusting cell references to adjacent rows, but it does not automatically apply to every sheet nor handle manual update requests or conditional formatting-based values.

Step-by-step explanation:

The auto-fill feature in Smartsheet does not apply automatically to every sheet but can be used to facilitate data entry when handling patterns or formulas. The two functions that auto-fill can perform are:

• Continue patterns of formatting: Auto-fill can detect and continue a pattern of formatting applied to a series of cells.
• Apply formulas and adjust cell references to adjacent rows: When dragging the fill handle, Smartsheet auto-fills cells with formulas and automatically adjusts cell references to match the new row numbers.

It is important to note that auto-fill does not copy manual update requests nor generate numeric values based on conditional formatting rules.