It gives the user the ability to create formulae. SSO level Enterprise security. One can easily import an Excel to start with Smartsheet and export as well. Inter-connectivity between different smart sheets. A lot of In-built templates are already there for users help. One can create separate...
Using the gui to perform vlookup should create a working formula (one would hope) but it doesn’t. The simplest functionality is missing, way better off using excel. Date of experience: March 31, 2021 UsefulShare Previous1234Next page Company activitySee all Claimed profile Hasn’t replied ...
I could move to Smartsheet - cascading dropdowns, setting a field's value with automation, setting a form field's value based on another field or formula, editing an existing item via a form (not an update request), extract time stamping from cell history to be able to report on it. ...
OKRs are about value and impact, which is not the same as keeping busy while working toward an individual performance review. OKRs are a simple tool to implement. It takes just a few hours each quarter to check and review them. A fast-cadence, or work period, process engages each team’...
Formula Support: Evaluate formulas in cell data. Master Detail/Subtables/Forms: Expand rows to reveal child data. Drag and Drop: Drag and drop in rows and columns. Sorting: Multiple options, customizable per column, with advanced event handling. Filtering: Predefined system filters. Preserve existi...
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.Find examples of how other Smartsheet customers use this function ...
If you have an Enterprise plan, you canuse AI to help write and troubleshoot formulas. Use theFormula Handbook templateto find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used...
Google Sheets is not quite as robust as Excel in terms of functionality. It has fewer formula functions, a less accessible toolset, and you can’t set up any automation macros. What Google Sheets does have, however, is quite good for basic users: real-time collaboration abilities. This mean...
This will not work in December. Next step To make this work in December we need a slightly different formula to find the start of the next month. This formula creates a date where the year is today's year plus one the month is the first month of the year (January) ...
To find the rows containing a pure number value using a filter, you need to convert the number to text. You can do that by creating a new column and the formula: =[NumberColumn]1 + "" where [NumberColumn] is the name of the column and row number is 1. Copy that formula to the...