-
Automation for creating a Template of new child rows when a Parent is copied from another sheet?
I'm working on creating some workflows that will copy information from a change order tracker sheet into a resource assignment tracker sheet. Ideally, I'ld like to grab key details from the change order tracker (number & name) over to a resource assignment tracker, then have additoinal rows added on the resource assignment…
-
Dashboard
I have a metrics sheet that I send every Monday to leadership. However, I'm finding that I need to look at prior weekly metrics for comparison. Since my metrics sheet updates constantly, how would I capture that data without having to log it manually each week? I know this is a vague question. My formula knowledge is…
-
Number column with leading zeroes
I need a way to keep leading zeroes for numbers in a column, but also keep them in number format for sorting purposes. These are test codes so leading zeroes are necessary but Smartsheet kept converting them into text.
-
Projektfortschritt innerhalb der letzten 30 Tage
Auf einem Projektplan wird mir der Erfüllungsgrad des Vorhabens durch die Abhängigkeitseinstellungen (Start/Ende/Erfüllungsgrad) wiedergegeben. Auf einem Projektedashboard möchte ich gerne tagesaktuell, jeweils die zurückliegenden 30Tage betrachten und für diesen Zeitraum (Datum heute/-30 Tage) den %tualen Fortschritt…
-
Countifs f-la
Hello, to this formula how would i add another sheet to get the match from? this formula says: match employee name, and if the column (sheet 1) has this document title return green, if it doesn't return red (sheet 2). Now i would like it to do the same thing but from a different sheet and return to the same sheet?…
-
Using Smartsheet to create Time Off Request Calendar, Dynamic View, Form, Report, in Dashboard
Hi all, Through some trial and error I created a Time Off Request system for my team (80 people) I started with grid rows: Employee Email (text), Supervisor Email (text), Division (drop down), Time Type (drop down: Vacation/Personal/Admin/Comp OR Sick/Bereavment/Jury Duty), Start Date (date), End Date (date), Partial Day…
-
Formula help please! What formula to mark the parent row "Complete" with an "Not Applicable" task?
In my status column I am using this formula auto update my my parent row: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Not Started") > 0, "In…
-
Formula to calculate the difference between two numbers based on a month in another column
I am unsure if it is possible to do what I want, but I wanted to ask. I have attached a copy of my grid. I want a formula to calculate the difference between the largest and smallest numbers for each well for each month. For example, for well #2 in month one, find the largest number (58650300) and subtract the smallest…
-
How do I pull the fourth, fifth and sixth name from a multiple-contact column?
In Smartsheet I have a contact column (Project Support) that can have up to six contacts (first name + last name), for example Jane Doe. I then have six other Test/Number columns that pull the first contact, the second contact, the third contact, the fourth contact, the fifth contact and the sixth contact. The first…
-
Pivot Table Summaries Getting #REF Error?
I have a few pivot tables set to update weekly, and seem to be refreshing the actual numbers just fine. However, I have some summary functions set up that have totally stopped working, instead giving a #REF Error: I'm a little surprised, as it worked perfectly (with real cell references, not #REFs) when I originally set it…
