I have been a smartsheet user for about 3 years. I started as a free user and moved into the licensed use and now I'm making sheets and reports like a pro! Thanks for a great product! :)
This discussion has been merged.
I have 5 different sheets representing 5 different projects in 1 program of work. So I am creating reports to bring those 5 sheets together to get a program level view. For one report, I want to see timings in a gantt view and color the bars based on the project sheet. However, I can't do this without changing the…
Hello, I am trying to count number of late documents within a specific section of the sheet. I have been able to do it successfully using row numbers but we change rows frequently because it is a roster type list I don't want to have to edit the formula each time. The third argument I wanted to use was to use their teams…
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
Is there a way to automate sending attachment (attachment in row) to specific e-mail, when a new row is added? Maybe through Smartsheet workflow, or Microsoft automate?
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
Is there a way to put a sheet into the dashboard that can be edited from the Dashboard?
Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing…
Hello! I am trying to figure out how I can autofill a column in a RAID Log sheet based on the project name entered in a cell in the Project Plan sheet. What I tried: First, in the RIAD Log I added a "Project Name Helper" column and linked it to the cell that has the project name in the Project Plan sheet. I then added a…