Pros and Cons Document Builder - e.g. all the contracts are generated automatically with data from Smartsheet. Ticketing Systems - using forms we can create tickets that are automatically assigned to preferred people. Request for update - if we need to have updated data in some cells but we ...
-different views: calendar, grid, card, and Gantt Cons: - not all reminders can be set with time to remind - can't add a conditional formatting based on time - if your Smartsheet is big, formulas added can take forever to update the information, so you need to refresh it all times...
SmartSheet Alerts is a great feature not provided by Google Docs and works wonderfully with SmartSheet Web Forms. We're alerted of a submission for every entry, immediately or once daily if desired. Update Requests allow for easy tracking and follow up of action items. I call it Google Docs...
If the company can articulate a vision, OKRs help employees see and manifest it. Staff aren’t just producing widgets; they know why they're doing what they’re doing, and they have some control. Delegates control to the lowest level of the hierarchy to do what needs to get done. “...
I Want to SUM the cells in the "Post Score" column only if the "Due Date" is before or equal to the respective "Date" (from table 2). BUT if there are two or more cells in the "Post Score" column that meet this criteria then I want to only SUM the MIN values...
This formula uses the IF and simple multiplication functions: IF looks at the price cell, and if that cell is blank, it returns an empty string "", so the total cell appears empty. If there is something in the price cell but nothing in the quantity cell, the total cell has $-. To...
Checks for a calculation error within another formulaLearn more ISEVEN Logic ISEVEN(number) Checks whether a number is even. Note that this function only works with whole numbers. If a value is even, this function returns "True." If the value is odd, this function returns "False."Learn mor...
In theFiltermenu, your filter's name appears--it shows asUnamed Filterif the filter is unnamed. If you shared the filter, the share iconappears next to the filter name. Modify a filter You can always go back and change the conditions of an existing filter: ...
The formula is working as expected when there is a date present in the column, but I'm encountering the #INVALID DATA TYPE error when the field is blank. Here is the formula I'm using: =IFERROR(DATE(YEAR([Date of OK to Release (system-generated)]@row), MONTH([Date of OK...
So this formula gives us the last day of the current month. =DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1 If you use that to replace the fixed date the 1st formula (=Date@row - TODAY(), which calculates the number of days between now and a fixed date) you can calculate...