-
Summarty roll-up sheet - Date error
Hello, New issue here. I am trying to do a summary roll-up of some sheet metrics. my goal is to publish this to the dashboard for ease of use. All of the metrics are based on the top cell (in green) called "Mother ID". When this number changes, so too does the associated info. One of the metrics I am trying to pull is a…
-
How to create a Sheet Summary for the last 7 days ?
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:Complete, "0", Created:Created, TODAY(-7))
-
Forms that need to incorporate multiple line entries
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed Are we able to set up a Smartsheet form to…
-
Dashboard Formula for Projects Within Date Range
Hi there, I'm trying to add a widget to my dashboard that tracks how many projects were initiated by year. In the dashboard metrics sheet, I reference the project intake sheet but cannot get the correct formula to count the number of projects by year. For reference, on the project intake sheet, the due date column has the…
-
Help with a formula
Hi, I need help with the formula: If percentage is less than 100% and the Go Live Date is in the future = "Ongoing" If percentage is less than 100% and the Go Live Date is in the past = "Late" If percentage is = 100% then we are done no matter if the Go live date is past or future. Please help. Thank you, Ana
-
Count if function on dates
Hi, Can someone help me how to use count if to calculate the no of days that an event happens in a month and create a monthly report based on that?
-
How do I utilize conditional formatting to highlight cells that are past due at different levels?
I want to highlight cells in my due dates column that are past due, current and upcoming. For example if the due date is past due by 21 days, I want that cell to be highlighted red, past due 14 days, highlight orange, past due only 7 days, highlight yellow. If the due date is in the future, I want it highlighted blue. I…
-
Specific cell reference in update request text
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 the project name, but all the subfolders remain “generic” in order for the links between them to continue working if we make…
-
how to omit 0 in graphs in a dashboard for a cleaner look
hi! I want my graph to only show values greater than 0. I've tried cleaning up my rows by adding a formula to leave cells blank if the value is zero. however, when I add the graph to my dashboard all values are showing and it looks really messy. this graph comes from different values but just to get a visual
-
Index Collect with Dates
Hi, I'm looking to get a bunch of different outputs based on: 1) an account being the smallest/largest (min(contract spend)) 2) an account being in a given month ({Assigned Date}, IFERROR(MONTH(@cell), 0) = MONTH([Month (just update top row)]@row)) 3) various other variables such as customer segment, etc The thing is, I…