-
SUMIF on Cross Sheets
Hello, I've been trying to create a roll-up based on "Region" from another sheet and I either get "0" or invalid argument. On inventory sheet I have multiple columns with Budget, Actuals, ect and would like to sumif based on Region. The formula below returns "0" =SUMIF({Inventory Range 1}, {Inventory Range 2} = "ProServ…
-
Automatic RollUp of data from multiple projects
Hello everyone ! I could use some help with some dashboard 101. I've been trying to find a way to roll up data for a while without success. Let me explain the situation: I've created a "project folder template" (including sheets, report and a dashboard) that I can easily copy for every new project I'm creating (please…
-
Formula Help!!!!! PLEASE
I have a data set with a bunch of dates 09/03/19 09/04/19 08/19/19 07/01/19 You get the idea.... Im trying to get a count of "incidents" by month... but I cant get the formula to work!!! July = 10 Ive tried... (below) and many others... =COUNTIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER)…
-
Reporting progress between date ranges
Dear Community, I have searched the community for some solutions for what I am trying to achieve…but can’t quite get there. I am working on some metrics around planned vs actual progress that I will plot on a chart. I have created a ‘metrics’ sheet to count the tasks planned to be complete at the lowest outline level from…
-
Server/Local sheets get out of sync, some permanently
Hi all, I am working with SS support but I thought I would reach out here as well According to T2 support ...If our server has not processed all data/ formulas before a save is made the sheet may show a different version than our server shows. In most cases the dirty save only lasts for the first 2 rounds of saves.... This…
-
Calculate RAG Overall Project Status
I have projects that are recording Red, Yellow, Green for multiple categories (Budget, Scope, Schedule, Resources), and I would like to be able to calculate the Overall Health by evaluating each of these individual status' and pulling the lowest color as the overall status. What I need to be able to do is calculate the…
-
If Current Month
Hi I'm trying to write a formula that will show me a column for the current Month Currently formula =If(Month(date column)= 9, [Project]1)- This works and displays the correct cell, however I want the column to change with the month so I tried= IF(Month(date column)=Month(Today()), [Project]1), I get an error Any…
-
Workload over Calendar Duration
I am very new to Smartsheets and am in process of educating myself on the product to help develop some staffing workload tools on a project basis over time. The goal is to help us analyze how employees are allocated on a project over a calender timeline. For example, we use project milestone deadlines to break up a project…
-
Formula to see if someone is available
I am trying to build a formula that references another sheet. The goal is to be able to see if someone is working on a project currently. In the reference sheet we have the start date and end date and the Talent's name. So, I am guessing it is going to have to be a IF/AND formula and the conditions will need to include the…
-
COLLECT – IF – DISTINCT Challenge
I want to JOIN(COLLECT) unique, distinct instances of a date given values in other columns. I have a history log of participant registration dates. The participant can register more than one time on a given date. I want to JOIN(COLLECT) all of the unique registration dates an individual registers. Is this possible? Table 1…
