-
=COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) Formula help!
Currently using =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) with check-boxes as a quick look to tell how many deliverables have currently been accounted for. I need to add additional lines under the parent row, but don't want them to count toward the total shown at the top. Is there a way to do this?
-
Setting predecessors with multiple tasks
I would like to have Task D begin when Task A or Task B is completed. How can I set multiple predecessors? Task Name | Start Date | End Date | Duration | Predecessor Task A | 7/1/2021 Task B | 7/11/2021 Task C | Start Date should be 7/1 is Task A completes first or 7/11 if Task B completes first.
-
COUNTIFS formula with OR and FIND formulas
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 contact list so I need to use a FIND formula. So the mix looks like this: =COUNTIFS({WTE}, $[Task Name]@row, OR({Assigned},…
-
Bring Task to a separated Smartsheet if due date
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 that are about to get due. How can I do this? Thank you
-
How to combine multiple excel sheets in one smartsheet?
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 sheets in one smartsheet? Is there any way to copy and paste columns in smarsheet? Please help and let me know all…
-
Help w/multiple if statements
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 is in the Materials in House column and Printer column. The Materials in House column has pre-populated dates I manually…
-
Project Management Template- Why headers in row 1?
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 in row 1 of in most (maybe all?) of the elements of this set of templates? I thought maybe they were used as references in…
-
Can I create a report/Sheet that would capture all conversations on multiple sheets in a workspace?
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 be done?
-
Update Columns in Existing Row Using Forms
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, Actual Date Completed, etc.) Each row is auto-numbered for tracking. Is there a method for a form or process to create…
-
Sheet Summary Report Builder only shows the system columns
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 helpful if I cannot merge together data from columns other than the system columns. Am I doing something wrong?
