-
How to write a running total in a list
Hello, I am wondering how to write a running total in a list where the first occurrence will have a value of 1, the second occurrence will have a value of 2, and so on. In Excel, the formula would use COUNTIF but I can not find the smartsheet counterpart. Thanks everyone!
-
How to combine formulas?
Hi all, I am trying to do some simple calculations for a project dashboard, e.g. showing the number of actions that are "not started", "in progress" (or those that are not complete or not cancelled) and that are also overdue, i.e. less than today's date. I managed to calculate the number of open actions, I also managed to…
-
Formula to sum values based on multiple cells.
Hi All, I am managing a material tracking sheet and I need a little bit of help with the following: I need a formula (or some method) to sum values of cells in a column called 'Qty'' based on the info in 3 other columns. So the formula will find all the rows with where the PO No. cells match and the Material Description…
-
Not all "Actual" bar show in gantt chart
Hi, Some of the tasks/sub-activities in my gantt chart do not show the "actual" bar even there is a reported progress (e.g. below activity with 25% progress). I'd appreciate any advise. @Andrée Starå @Genevieve P. perhaps you can assist? Thanks IPC
-
vlook up
Hi all I am trying to use vlook up to bring back a set of requirements from a requirement sheet into my travel sheet So when a "mine site" is site 1, then return the relevant information to the Site Requirement column this is my sheet with the specifications per site that specifies any requirements per site
-
Metrics Sheet Formula to Calculate Average of Numbers in Column on Main Sheet
Hi, I have a main sheet with the columns seen below. As stated in the notes, I have not accounted for skipping the calculations when a date missing in a row. That's my first request -- correcting the first 3 formulas. Second, I have a metrics sheet where I want to have a formula calculate the average of the numbers in the…
-
Examples of Count IF + Distinct
Hi SmartSheet Community! I have many instances where I want to know the number of distinct values based on specific criteria. I think I need a combination of COUNTIF and DISTINCT. Can anyone provide some guidance? Here is what I have so far but its not working: =COUNTIF(DISTINCT(TransactionRole:TransactionRole, HAS(@cell,…
-
Running job to date hours on a project per task code?
How can I have a running total of Job hours to date per task code display on a sheet that shows actual hours vs estimated hours? The problem I am running into is: I have a weekly time sheet that is filled out for the employees on a particular project. The time has to be separated out by Straight Time, Over Time, Double…
-
CountIFS Multi-Select Criteria
Smartsheet Community: My Change Type Column Allows Multiple Values. Therefore, my Formula is Looking to See if it Has Scope or Time. If it does, then it Should Count. I Think The HAS Part of My Formula is Out of Place. Current Formula: =COUNTIFS(Project:Project, "OPAL", [Change Type]:[Change Type], HAS(@cell, "Scope")),…
-
Workflow - Not running when sheet is not open
Hello, I'm using the JIRA connector and when a sprint is closed and another one is opened, I'm tracking that change on a smartsheet sheet. I would like to have a workflow to perform a few actions upon that change when that change occurs. The sprint does not start always at the same or at the same time of the day, that's…