-
sum IF formula
Hello Me again... sorry.. I need to summarize total number of employees across the country by location. I have column with location names, and a column with total number of employees... For example I need to know for ALL locations how many employees are Remote I tried =sumif([Location (for summary)]1:[Location (for…
-
COUNTIFS and NOT Function
I'm looking to count the number of instances an epic is listed, but to exclude Closed and Done ones. I am trying this formula which gives an error =COUNTIFS(JIRA:JIRA, CONTAINS("TPM", @cell), [Issue Type]:[Issue Type], "Epic", NOT(Status:Status, "Closed", "Done")) Any suggestions?
-
COUNTIFS within a Date Range
Hello, I have a column of dates that are formatted as dates. I am trying to use COUNTIFS to tally the number of instances in which a date from the column is less than 1 month from today, between 1 and 3 months from today, between 3 and 6 months away, and between 6 and 12 or more months away. For less than one month away, I…
-
Formulas Not Pulling
We currently utilize a very large global onboarding smartsheet. When a new hire accepts a position, the onboarding team uses a form to manually add them to the tracker so we can assign out the onboarding tasks and track progress. As part of a business initiative, we also have hidden column to track the amount of time spent…
-
Adding a date cell a cell is changed
Is there a way to add a date to a row, when a status field is changed? I tried the "Modified (Date)" but that will change whenever any cell in the row is updated. I only want the date to update when the one specific cell changes. Thank you.
-
Incorrect network days
Hi All, I'm trying to replicate the same formula in smartsheet, the issue is network days are calculated incorrectly, is my formula wrong? I have attached the image: from Jun 3 - Jun 19 there are 13 network days, while splitting for the week beginning Jun 15, it only shows 3 workdays instead of 5. any advise/suggestions?
-
Count Projects by Year within a range
Hi All! I've been scratching my head with a way to count all projects where the Start Sate or End Date have a year that matches a bucket. Fore example, if a project's start date is 2020 or end date is 2020, then I need to count it in the 2020 sheet summary. A project where the start is 2019 and end is 2020 would also be…
-
SUMIFS and Contains conditions
Hi all- I have a formula that refers to another sheet to sum costs based on some criteria: =SUMIFS({Professional Services Project Costs Amount}, {Professional Services Project Costs Grant Code}, $[Budget Allocated]$8, {Professional Services Project Costs Category}, CONTAINS([Budget Category]28, @cell)) I'd like to add…
-
IF cell matches criteria in one column, THEN return other columns from matching row
Help, please! I am trying to search a MASTER sheet for ALL ROWS that match two criteria (MASTER Author-Partner matches the value in [Project1], and MASTER Project category matches Project@row), and then return the contents of certain cells within each matching row (Title/Topic, Product type, Status, Due Date). I have had…
-
Conditional Logic Forms
We have a form that will have yes/no logic. If Yes(problem is resolved with the previous information provided in logic) is selected we want them to back out of the form or display a "thank you, please submit if you have any additional questions" It doesn't appear the functionality is there, but does anyone have work around?