Hi, I am trying to do a few things. First, I would like to pull symbols into the Sheet Summary based on the following criteria: Most Recent Entry for Site A. Pull symbol from the "▲ ▼" column. Second,…
Hi there - I am not understanding how to use this COUNTIFS formula above. I am in the process of creating a SmartSheet dashboard for my team from an intake tracker we have. I would like to use the met…
I am trying to find out how to summarize (count) the number of items that have been completed in the last 7 day? but my formula is reading 0? i think there might be a syntax error =COUNTIFS(Complete:C…
Hello! My examples are in French, but as SS is the same, you should understand with the visuals. I used a template as a base for my project management office. In this example, we create a folder with …
Hi, I need help creating a formula to summarize an average using Sheet Summary Columns, I have the following sheet columns: Current Date, Average Rating, I have the following summary columns: From Dat…
Hi, I'd like to display Red, Yellow, Green in a Sheet Summary field based on the calculation of two other fields, Past Due and Total Tasks. I'd like it to show Red if Past Due divided by Total Tasks i…
I feel like I'm going crazy but I can't figure out how to copy a value in my clipboard from a smartsheet summary. There's no option in the dropdown and whenever I click into the field it tries to edit…
I'd like to generate a report that shows : Which tasks are in progress ( Including their parent ) which tasks are at risk ( Defined by tasks that were supposed to be started but are not started yet ) …
Looking to find a formula for number of tasks in each status- I have this so far but I'm getting the #UNPARSEABLE error. Please help =COUNTIFS([Status]:[Status], CONTAINS("Complete" @cell)", [%Complet…