-
SUMIF with specific date from date range
Hi, I'm trying to figure out if it's possible sum up all the mouse cages we are using at a given date. E.g. If I enter "5/20/2020", it will count the cages from study 1, 3, and 4, total of 55 cages. I tried the SUMIF formula like below but keep getting error message. =SUMIF([Column8]8:[Column8]8, AND(Start1:Start4 <=…
-
#BLOCKED on Dashboards
Hi Community! I have built a data visualization dashboard that runs off a "summary" sheet. The summary sheet is all formulas that average data from a master sheet. My problem is, instead of the Dashboard updating live based on the data in the summary sheet, it breaks and shows #BLOCKED every time the master sheet updates.…
-
INDEX from another sheet's multi-contact column
Hi, I have a "Project Master" sheet that lists all our projects and has a multi-contact column where I keep all the resources (contacts) that are working on each project. On a set of other sheets, I am trying to collect and index the set of projects to which a single resource is assigned (and I need that to be a metric…
-
How do I use =SUM(CHILDREN()) correctly?
Good afternoon, I'm trying to use the sum children function for smartsheet designed for budgets. I was able to sum the initial 5 rows correctly, then added 6th row to test the children function. I put in the new formual =SUM(CHILDREN()) and when I press enter, the value turns from the original budget price to zero. Any…
-
RYG Automation using TODAY, AND, and OR functions
This discussion was created from comments split from: Automate RYG For Project Tasks.
-
How to calculate a percent of tasks completed WTD and MTD based on percent of month complete
I have a set number of tasks that individuals are expected to complete for each day, week and month. I have combined all of the tasks to show a percent of tasks completed. however, the issue with is this approach is that it does not account for the percent of the week or month currently complete. what i really what the…
-
have a way to apply a default formula to new row automatically
I would request a way to apply that when any information is added into a new row that if there is a column that I want a specific formula in, that this formula is applied automatically to the cell in that new row. This functionality seems to work when I am entering a new line via a form. It also "sort of" happens when the…
-
I am trying to create a form where if Work Location = X then a drop down list of employees appears.
For example, if I create a column of employee names as a drop down, and I create a column for location, is it possible when I select a location, it modifies which employees show up in the employee column drop down?
-
SumIFs with Multiple Conditions and Reference Sheet
Hello, I have two sheets. On Sheet 1, I'm trying to write a statement that looks up all occurrences of each team member, like John Smith, on Sheet 1 and sums up the story points by month using the Resolved Column. See Jan-Pt summary. Each sheet only shows the first line. Sheet 1 will have many team members and month by…
-
How can I create a stacked bar graph that shows different sets of data?
Hi! So I have two sets of data that I would like to graph using a stacked chart. Data set 1 contains a number of actions that are divided by month, for example, the month of May has 5 actions and the month of June has 3. Data set 2 contains the same actions, however, in this set they are divided by source (e.g. deviations,…
