In one of my sheets, I can create a filter for the field "Project Manager" In the field(s) Show columns that match...if I click the dropdown arrow to give me the options for selection, I do, in fact, …
Oh boy I have a good one today. Please Help! On Friday I was working on my data base sheet, linking cells in a couple different columns to another sheet. (I hid the columns in between, to make it easi…
Hello, I'm drawing a blank on why this filter is not working correctly. I process the archive of the data in this log and will archive every week the items that are 21 days or older. This is how I hav…
I am trying to create a Smartsheet SUMIFS formula where if the value in a cell in column 1 is not blank, and the value in a cell in column 2 is US Commercial, and the value in a cell in column 3 is 20…
Hello, I have raised a ticket twice for the same issue and have yet to receive any reply a month later. I have taken a screenshot the second ticket raised to capture date and ticket number as nothing …
I want to create a Smartsheet project that has a Start Date of July 1, 2019 and End Date of September 1, 2020. I want to set the timeline to Years/months. When I view or print it, I only want to see t…
Hello, When I set the column type as "Date", I need to be able to choose different formats. For example, it currently defaults to MM/DD/YYYY, but I need the column to default to MM/YY or MM/YYYY. This…
Im having a little bit of a hard time trying to make formulas longer and saving column space(s). For instance when I run into an issue of creating a formula in 1 cell i sometimes create a new column a…
I am trying to build a UI using Google scripts to display the changes made to any given row. In other words, I want to capture a list of modified date, modified by and what was changed in a row if any…
Hi I'm finding that reports are not refreshing accurately when the underlaying data, in a smartsheet, has changed (and been saved before you ask). The source data is around 20 rows so this should not …