I am trying to get a count of completed tasks by a team by month across multiple sheets. I've created this formula in the sheet summary: =COUNTIFS(Status:Status, "Complete", [Team Assignment]:[Team As…
Hello, I added the new roundup formula to my sheet and this cause all of my reports that reference this column to show up as #unparseable only on the report. This shows as a value on the main sheet. T…
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will con…
Greetings SMARTsheeters... Not sure if what I'd like to do is possible in SMARTsheet, but here goes... I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupd…
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blan…
Does anyone know if there is a way to produce a report or a list of rows whereby Column A has changed in the last n number of days? I'm trying to produce an exec level weekly report of key projects wh…
With the recent (Sept 19, 2019) update, non-licensed users no longer have the ability to update their Report Builder within SmartSheet. This poses a significant problem for my company, as we have mult…
I am using a pre-built template dashboard and am trying to see the data that the chart widget is referencing which is displaying on the dashboard but am unable to determine what data is being used.
Hello, would much appreciate it if anyone is able to help me out. I would like to be able to pull both parent and child rows of a sheet into a report based on a criteria which only exists in the paren…