-
Standard Milestone Names
I am creating a project template for my department to use for all projects. I have created drop menus to limit certain column entries to a controlled list of choices. I would like to do something similar to control how the user names a milestone. Is there a way to have a list of standard milestone names for the user to…
-
Formula Help: Completed Project Count for Parent Rows Only
Hello, I am new to SmartSheet, and I am trying to create a formula that adds up the total number of projects that have a check mark in a Completed column. Note: I created a row to star all of the projects in parent rows (to distinguish from tasks in the children rows). So essentially, I want to add up all of the starred…
-
Formula return blank result
I've attempted multiple times to create a function that result in Blue, Yellow, Green, Red health and it has been unsuccessful. Here are the results that I am aiming at: On Track > "Complete" "In Progress" = Green Ahead > "Complete" = Green Ahead > "In Progress" = Blue At Risk > "Not Started" "In Progress" = Red Behind >…
-
Cross-Sheet Reference Limit
Concerning the current limit of 25,000 total cross-sheet references per sheet - is there an easy way to determine how many are currently being used on any given sheet? Thanks!
-
How to create report with rows instead of columns?
Why does Smartsheet only allow you to make a report with columns and not rows? I'm using my sheet to coordinate data for events. Each row has a specific event, each column has different details for the events (date, location, hotel, meals, etc) and I need to take information from only certain rows to create a report for…
-
HOW TO REMOVE #DIVIDE BY ZERO AND MAKE CELL BLANK
I am trying to average a customer feedback section of my sheet. But if the cells where the data to be averaged will come from, the result section shows #Divide by Zero. I use the formula =AVG([column1:column2]). What's the formula I need to use for this? I saw in the other community discussion that I can use IFERROR but I…
-
Send a link to a report to users that have tasks due that day
I'm not sure what the best work flow is for this but here is my current setup: * I have a task list with all tasks for the duration of a project. * I have reports that list all tasks due within the next day or week for the "current user" * Currently users get alerts for every task that is due on that day (multiple alerts /…
-
Calendar App Tab Name
As someone who is always rocking 2-5 open tabs in the calendar app, it would be EXTREMELY helpful if the name was on the tab title at the top of my browser. When I am looking for a specific calendar, I have to click through all my open calendars (they all just say "Smartsheet Calendar") to find the one I'm looking for
-
Metric Sheet -Showing Trending
I set up a metric sheet that with CountIfs formulas to show Monthly Stats.. I just realized that when I change the reporting period on my source sheet , I will lose the value counted in the previous reporting period... Is there a way to lock the data values in the previous reporting periods... arggh
-
Reporting/view - A3
Hello, Has anyone created a view or report which mimics the look and feel of A3 documents popularized at Toyota? Thanks! Mark
