Formulas
Discussion List
- Hello Smartsheet Community, I have a metric sheet set up where I am pulling from a much larger budget sheet - on my metric sheet, I want to pull in the market and due dates based on the project descri…
- Hello, I am running a Count(Collect) on a sheet with 8000 records. The formula calculates for a small number of records but if I make it a column formula or copy it to every cell then the sheet crashe…
- Hi All, Need some guidance is there way to automate column 20 to auto populate whatever the parent cell on task name? @Paul Newcome It's Maz Uddin, this is a new account. Please can you answer if you …
- COUNTIFS( range1, criterion1, [ range2, criterion2... ]) OK, I'm stuck. When using COUNTIFS, and both ranges only cover 1 column each, or both ranges cover multiple column, it works perfectly. But, …
- I have a grid that contains an employee's level of expertise is a specific skill. There are 90 skills listed (columns) and around 50 employees. Each cell contains None, Beginner, Intermediate, or Expe…
- Hello, I have two questions. Can someone help me understand the coding created at the end of this string query I use for a prepopulated form? Also, when I add a new section looking for the "Time," do …
- Hi all - I am trying to create a long formula and need some assistance. For a Risk tracker I have 2 columns (Probability and Impact) both which have list values of High, Medium, Low. Based on those se…
- Hi, Smartsheet champions. Does anybody have ideas on creating a view like below (or similar) on Overdue tasks? Perhaps creating a column in tasks sheet with formulas to calculate the Days Ago number a…
- I have created a budget sheet template and need to add seasonlisation to identify cross-charges by month. Rather than doing this manually every time, I would like to add a formula that pulls the data …
- I am trying to link cells to another sheet (Name column) based on the specific local chosen that they are in (Local #26). I have tried using this formula below, but it only populates one name not the …
