-
INDEX/MATCH with checkboxes and contacts
Hello, I am working on a sheet that I created that will act like a team member matrix. In the sheet I have two columns that list the name of the project and another column listing the names of who is apart of the project. The other columns in the sheet are all identifiers like (project owner, sponsor, leader, etc.) and are…
-
Count IF formula
Hello, I am trying to find the formula to use to count the number of rows assigned to an email are on a data sheet and will need counts specific for each month. Which I will adjust the formula for all the other columns months. Below I have how to pull for the user email but not sure how to add in the argument for the…
-
Anyone able to help figure out this formula?
I would very much appreciate anyone's help on this. I have moved the brackets around and changed anything I can think of, but it's coming up "unparseable". The column headers and sheet references are right. =IF(TODAY() >= [Quarter Start]@row, COUNTIFS({HR mock-up sheet START DATE}, @cell <= [Quarter End]@row, {HR mock-up…
-
Copy Row Automation - Eliminating Duplicates OR keeping latest Row entry/update
Hello fellow Smartsheeters, I am trying to capture entries from a project level RAID log and pushing them (based on specific criteria) to an Enterprise level RAID log. Specifically, any Risks or Issues that are created and updated need to be pushed to another sheet. I am familiar and frequently use the Copy Row Automation…
-
Calculating how long a query has been worked on and how long it remains at particular statues for
Relating to this previous community query, I've got 2x similar queries.. I've posted it in that conversation but wasn't sure if it bumped it up the queue, so thought I'd post a new thread just in case it wasn't. I've used the formula @Paul Newcome provided in his post to tell me how long since the creation date the…
-
Countifs counting this not in criteria
I am using [Method helper] to tell me when we have more than one online training on a date where Notes= PD =COUNTIFS(Notes:Notes, "PD", [Date 1]:[Date 1], [Date 1]@row, Platform:Platform, Platform@row, Platform:Platform, "online") > 1 I have tried to specifically say, do not count anything with CDA in it, in a variety of…
-
Do leading zeroes affect "duplicate flag" formulas?
I have a sheet with a column of the 'Text/Number' type called "ID Number." My intent is to have another column of the 'Checkbox' type (called "Flag Duplicate") to show at a glance that an "ID Number" has been duplicated (the data in the "ID Number" row should be unique in each cell within the column). I used a column…
-
Task completion (%)
Hello everyone, is there a way to set the % complete based on the task status? I have a table [state ; % complete] I tried with "VLOOKUP" function but isn't possible to insert formulas in the field. Help me please! Thanks
-
Automatic formula
Hello everyone, In some fields in my sheets I have formulas. Is there a way to automatically report these formulas when I add new rows? Thanks
-
COUNTIFS and DATE RANGE
Hello Everyone! I followed a lot of the tips and suggestions that were already on the threads and for some reason I am unable to get the formula to do what I want it to do! I am trying to figure out how many of our initiatives are in a certain stage during a certain date range. The formula that I am using is…
