Hello all! I have a trouble with one formula. The idea is, that I need to find an engineer name in AT LEAST (that's why I am using OR) one of the columns. The problem is, that the second range is a co…
Hi, I have several tasks Smartsheet's to manage different projects. In order to avoid keep checking each Smartsheet for due dates, I would like to have a "Summary" Smartsheet that brings only tasks th…
Hello, I am trying to create one master sheet in smartsheet. I have 10 excel sheets with identical column names. I have created one master sheet with the same column name. How can I combine all those …
Hello! I am a new Smartsheet user trying to figure out if multiple if statements work with what I'm trying to do. I would like to automate the date in the Release to SGS/Printer column based on what i…
Hi all, Smartsheets newbie. I've been playing with the project management templates (they're terrific!) and working on customizing them for our needs. My question is, why are column headers repeated i…
I have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this b…
Hello, I have a sheet where I am tracking construction progress. There are a lot of data/calculations that my field personnel do not need. I want a simple interface for them to update data (% Complete…
I am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not …
Hi, Background: I have multiple Smartsheet files with around 1000 rows that each involves around 20 assigned individuals with various technology literacy. Due to assignees various technology literacy …
So, I am having an issue with my published dashboard. I have embedded a report utilizing the current user function. I have found that when my team accesses the dashboard by manually navigating to it t…