Formulas
Discussion List
- This discussion has been merged.
- Hello! How do I change the way a date is displayed? I need to change dates displayed as ""yyyy-mm-dd" to "yyyymmdd" for a report. Thank you!
- I need to create a formula that will find the next expense date based off 3 other column categories. The columns and their categories are as follows: Due Date (single date when expense is due), Progra…
- This discussion has been merged.
- Hello, I am working on creating a sheet that utilized data from a master sheet via links. I am struggling because the new sheet is not automatically updating when new info is added from the master she…
- I have created a workflow that goes through three different departments. I want to capture the date and time of a request (row) coming in, and the date and time of the next action and each action afte…
- Hello Everyone! I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combi…
- Hello, How do I calculate a person's age from their birthdate?
- I'm making a training matrix for my company. Source sheet is the "matrix" that will list all employees and their required trainings: *RowID is auto-numbered column *RowNo formula is =MATCH(RowID@row, …
- Hello! Quick question I've been stumped on. I have a sheet that tracks hours worked on different projects each month in a year. I want there to be a cell that displays the average of the most recent 3…