Keyword | CPC | PCC | Volume | Score | Length of keyword |
---|---|---|---|---|---|

smartsheet view formula bar | 1.38 | 0.2 | 263 | 10 | 27 |

smartsheet | 1.27 | 1 | 3177 | 48 | 10 |

view | 1.67 | 0.3 | 4508 | 26 | 4 |

formula | 1.7 | 0.4 | 6043 | 1 | 7 |

bar | 1.13 | 1 | 8612 | 37 | 3 |

Keyword | CPC | PCC | Volume | Score |
---|---|---|---|---|

smartsheet view formula bar | 0.13 | 0.6 | 6082 | 43 |

For the complete list of functions available in Smartsheet, see the Smartsheet Functions List. You can use the following operators in Smartsheet formulas. To edit an existing formula: Double-click a field containing the formula to open it for editing. Make your desired formula changes, and then press Enter.

After you create a formula, you can modify it at any time by double-clicking in the selected field or by pressing F2 (fn + F2 on a Mac). Smartsheet treats percentages as values between 0 and 1. When you create formulas in columns formatted for percent (using the Percentage Format button in the toolbar), use decimal values.

Formulas can include functions, such as SUM, AVG, or IF. Functions perform calculations with or manipulate data in sheets. For the complete list of functions available in Smartsheet, see the Smartsheet Functions List. You can use the following operators in Smartsheet formulas. To edit an existing formula:

Auto-fill—You can have Smartsheet automatically copy a formula to new, vertically adjacent fields that enter the sheet. When auto-filled, the new formula will automatically change its respective field references. Learn more about this functionality in the help articles on Drag-fill and Auto-filling Formulas and Formatting.