- [number]
-
number—[optional]The number of days before (negative number) or after (positive number) the current date
Smartsheetwillupdate all instances of the TODAY function in a sheet to the current date when you take any of the following actions:
- You open the sheet and save it
- You add a new row to the sheet from a form submission
- You make changes to the sheet from an update or approval request (more on these alertshere)
- You update the sheet by way of a report (more on reportshere)
- A linked cell updates the sheet (more on cell linkinghere)
- You open the sheet being referenced in a cross-sheet formula (more on cross sheet formulashere)
- You add a new row to the sheet from a move row or copy row workflow (more on these workflowshere)
- You update cells using a workflow, such as change cell, assign user, or record a date (see all sheet change workflow actionshere)
The following willnotupdate formulas that are using the TODAY function to the current date:
- A report referencing the function in the sheet is opened.
- A dashboard showing information from the sheet is opened.
You can use TODAY to compare other dates with the current date. For example, the formula =IF(TODAY() > [Due Date]@row, "Past Due") will insert "Past Due" into a cell once the current date has exceeded the estimated due date.
TIP: Use automated workflows to update your sheet on a daily basis. A workflow can trigger the TODAY function to refresh to today's date without opening the sheet. See the articleAutomatically update the TODAY function in formulasfor more information or use Bridge toSchedule Daily Sheet Save.
This example references the following sheet information:
| Transaction Total | Units Sold | 存货吗? | 销售日期 | Order Date | |
|---|---|---|---|---|---|
| 1 | 1,170.00 | 78 | true | 02/12/19 | 02/12/19 |
| 2 | 1,491.00 | 42 | false | 02/15/19 | 02/15/19 |
| 3 | 812.00 | 217 | true | 02/20/19 | 02/20/19 |
Given the table above, here are some examples of using TODAY in a sheet:
| Formula | Description | Result |
|---|---|---|
| =SUMIF([Sold Date]:[Sold Date], <=TODAY(), [Transaction Total]:[Transaction Total]) | Sums the values in theTransaction Totalcolumn, for rows where the date in the销售日期column is less than or equal to today’s date. All three rows meet the criteria. | 4.285 |
| =IF(AND([In Stock?]2 = false, [Order Date]2 <= TODAY(7)), "Red", "Green") | 如果检查box in row 2 of the存货吗?column is cleared (false) and the date in row 2 of theOrder Datecolumn is less than or equal to the date 7 days from today, the function returnsRed. Otherwise, it returnsGreen. | Red |
| =SUMIFS([Units Sold]:[Units Sold], [Sold Date]:[Sold Date], >=TODAY(-30), [In Stock?]:[In Stock?], true) | Sums the values in theUnits Soldcolumn, for rows where the date in the销售日期column is greater than or equal to the date 30 days ago, and the checkbox in the存货吗?column is selected (true). | 217 |
Still need help?
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 and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.