-
COUNTIFS - Multiple Columns if blank by person
I am looking to count by the person if they have not entered data in the cells within a column. If person A is missing six (6) cells within three (3) different columns then the calculation should only calculate that person one (1) time. I have created helper columns to calculate how many people have missed entering data.…
-
Need Help Sorting & Grouping "Day" Data By "Week"
I'm brand new to functions and Smartsheets in general so please bear with me as I attempt to learn with you all. I've read over the functions documentation and to be honest, it's a little over my head. I'm trying to suss out a step by step otherwise I get lost. But I'm hoping I'll get there eventually! Here's the nuts of…
-
IF Formula with Children
Hello Everyone, I am trying to figure out a formula that would show the children's status on the parent row. IF the children's "Status" column is "Completed" OR "Completed By Black Ops", the parent "Case Status" column should be "Completed", otherwise, "Pending" Thank you in advance.
-
COUNTIFS with OR and ISBLANK to find number of blank cells 7 days ago
Hi, I have a formula that is working to count the number of active employees in Role 1, Role 2, Role 3, and Role 4 who did not qualify because the date field is blank. =COUNTIFS({ROLLUP-EmpStatus}, "Active", {ROLLUP-Role}, OR(@cell = "Role 1", @cell = "Role 2", @cell = "Role 3", @cell = "Role 4"), {ROLLUP-QualifyDate},…
-
Year( formula issue
Can any one help me why this formula doesn't work. It results in #invalid operation =IF(YEAR([Project Works Commence]@row = 2022), WEEKNUMBER([Project Works Commence]@row), " ")
-
Is there a way to add data to one sheet and have it automatically pull to another sheet?
I have two sheets, and they share a similar column, but only that one column is consistent between the 2 sheets. The column is called "record ID#". I am hoping there is a way that once I add a new record ID # to one sheet (Sheet #1), that record ID # can automatically populate on my other sheet (Sheet #2). Just the record…
-
How to populate a column in a sheet based on a column from another?
Beginner here. I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each of the accounts these people have. I'd like each individual name to only be included…
-
If Error Vlookup multiple sheets
This is the formula i am using now. =IFERROR(VLOOKUP([Co#]@row, {Master Accounting Tracker 2022}, 4, false), VLOOKUP([Co#]@row, {Master Accounting Tracker Range 2}, 4, false)) How can I make this return a blank instead of #NO MATCH? Also, can you attach a third sheet to search if first two are errors?
-
Need help calculating number of credits with multiple AND and OR functions
Logic I am trying to achieve is above and the formula that is returning an #UNPARSEABLE error is above, too. I'll need to repeat this formula for each of the months, so I'll just replace the 1's with 2's or 3's or 4's, etc. depending on the month column. Thanks!
-
If Formula Help
I'm trying to return a date based on the presence of a checked box. I have project plan where we have multiple similar simultaneous activities going on. The PM will check a box to indicate the start date of the First one so I can run a report to show this date across multiple similar projects in my portfolio. I created a…
