-
What is wrong with my automated colour column formula?
I am looking to automate the colour “status” for my rows based on the health of the action - a calculation based on the ‘% Complete’ and the ‘Due Date’. The goal is to demonstrate a contextual health status. For example, even if an action is only 10%, if the due date is still 6+ months away, the action is still Green due…
-
Formula to show whichever is less
Hello, I'm working on a formula to show the remaining duration of a task. I'd like to calculate workdays using the planned end date minus either today or the planned start date, whichever is closer to the planned end date. For example, if the planned start date is 10/29/21 and the planned end date is 11/05/21, then the…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
=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…
