Formulas
Discussion List
- Good morning, friends of Smartsheet, I need some help working through a process. I have a worksheet that has a checkbox column called 'escalate'. When we check that box, the row shows up on a report t…
- Hi Good people I have two sheets - FTTH Program sheet and the PMO_DataDump sheet On the FTTH Program sheet i have the unique id - PN number and on the PMO_DataDump also have the unique id with duplica…
- I am trying to count the number of projects that began since Jan 1, 2024. I typed in the formula =COUNTIF([Start Date]:[Start Date], ">= Jan 1, 2024"). Basically I wanted to count the number of projec…
- I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but…
- Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the val…
- Hello, I have a formula to determine the days between two cells: =IF(OR([Status]@row = "CLOSED", ISDATE([Closure Date]@row) = 1), [Closure Date]@row - [Date Initiated]@row, TODAY() - [Date Initiated]@…
- Hey! I am wanting to count the number of projects in each department (e.g., Health Action) that are marked as active. I am currently using this formula where I manually enter how many inactive project…
- I have two sheets for a traning evaluation form. They both have a common column, TrainingID. Based on that column I want to bring in data from one sheet to another. Example: For all rows that have BLS…
- I am looking to create a formula that counts the how many times over the last 12 months escalations of a certain deal size occurred. Deal size is represented as range of AUM in text format. The curren…
- I am trying to create a formula on a sheet summary that returns the information in my row titled Total that corresponds with the most recent date within a specified year. I came up with the following …