Formulas
Discussion List
- I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date …
- Hi there I have a question to how to automatically link the count formula from one master list to individual sheet. Below is my workflow. I have created multiple individual sheets for each of my progr…
- I need help with my Health column formulas. I cannot figure out why it's not working. What am I missing? Available health options: Red, Yellow, Green, Gray Health formula: =IF(COUNT(CHILDREN()) > 0, I…
- My below formula keeps giving me an error and I can't see to find the problem. It also seems to not be recognizing the column references when the names match exactly. =COUNTIFS([Project Start Date]:[P…
- Hello, I have looked for this all over the smartsheet community, and while there are some responses, I still cannot get this formula to work. I need assistance with the following: I am looking for a c…
- Problem: How to automatically document historical values without using the automation workflow. I have a two-line graph of which one line (let's color it black) represents desired results within a dat…
- Our projects have a subfolder with any number of sheets that all have the same data layout. We need a summary sheet that fetches a status value from each child sheet, but i can't figure out how to do …
- Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date wh…
- Hello, I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names? Many thanks, Pltrmgrl…
- Back to SLA calculations, this calculation worked in the previous wave of Hypercare, but for some reason isn't doing so now. Background: We calculate SLA based on Priority Critical=4, High=8, Medium=2…