Is it possible to "center" the "vertical" alignment of the bars on a Gantt chart (in a Report, but also in a Sheet)? The default seems to be that they appear at the top of their row, but I'd like them…
I have a sheet where I've pulled a list of titles that exist on a series of URLs in either all caps or title case. I need to be able to identify or sort by the lines that are in all caps so that they …
I have a sheet of subscriptions for all our customers being populated from another system. This is a 1-many list. I want to create a sheet with only the selected customer's data and use that in the co…
I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it see…
A dashboard that I use daily now appears with "missing source" in a number of places and I have double checked the source is not missing and I am the owner of the dashboard and the source as they appe…
We are using the Project Schedule Baseline functionality, but recently learned that the Schedule can be Reset or Removed. Is there anyway to track how many times a Schedule has been 'Reset' or 'Remove…
Good morning, I am trying to pull calculate an average from data being pulled from another sheet. I want to be able to calculate the average duration, by month of completed projects. I basically want …
I have a smartsheet, it has a helper column titled Full Name, which is calculated using task name and parent names. In the report section, I select the sheet, and the specific column and criteria. but…
I need a formula for a sheet summary that I just cant wrap my head around, might even be two formulas working together...Maybe I am over thinking it. I need a formula to look at a "date1" column and a…
I am trying to compared two columns in my sheet, based on if the numbers in the column grew, shrunk, or were unchanged. I'd like to automatically show this with the up/down/unchanged symbol. Is this p…