-
Using functions in a sheet summary
I'm designing a tracker to track training credits. These training credits are used by specific learners who belong to specific workstreams. I'm trying to use the sheet summary to answer these 2 questions: How many training credits are used by a specific workstream, e.g., Technical? How many training credits are used by a…
-
Identifying Duplicates within a column
Can someone tell me what I am doing wrong here? =IF(COUNTIF([Name of Individual Impacted]@row:[Name of Individual Impacted]@row, [Name of Individual Impacted]@row1) > 1, 1) I am trying to identify duplicate case names within my master sheet. Screenshot included below. I keep receiving the unparseable message. :(
-
Month-to-Month Reporting Capture via Chart
So here's my source Sheet where we track issues and closure of these issues. As you can see I've created several helper columns (i.e., columns that are locked) in an attempt to retrieve and organize the data in such a way that I can then add a bar-graph chart on our Dashboard....one that captures for example: 1) Supplier-A…
-
Looking for help with IF(HAS function. If value not found, then do a vlookup.
Hi, my formula continues to return as #INCORRECT ARGUMENT SET. I want the cell to return a value of ZERO if the referenced cell HAS the word Closure. If it doesn't then I want it to do a vlookup. Here is my current formula returning the error: =IF(HAS([Project Type]@row, "Closure", 0, VLOOKUP([File ID]@row, {TM Completed…
-
Need to know if a formula is possible in Smartsheet
I have a formula from Excel that I can't get to work in Smartsheet, so I need to know if it is possible or not. =SUM($B$3:$B$26,"=1",$E$3:$E$26)+COUNTIFS($B$3:$B$26,"=1",$C3:$C26,"")*480 The first part, SUM, is looking to see if Column B is Shift 1, then sum Column E Plan DT. Second part, COUNTIFS, is again looking for…
-
Assistance with Averageif formula
Hello, The formula below was working great until I was asked to add a new requirment where I need to exclude values that are greater than 14 . Otherwise the average is incorrect if greater then 14 "cells" are included. I tried the Averageifs but got lost trying to figure it out so here is my original formulas sans the new…
-
How can I write a formula to pull data based on dynamic columns?
Hi all, I'm trying to write a formula that will pull row information based on dynamic Columns. My goal is to understand the difference in hours worked between last week and the week before. I would like to be able to flag if a Person has not updated hours in a week. I have a 'raw data' sheet which has team member names in…
-
How to cound items in a RAID log using the Health Color
Hello - I would like to reoprt the # of green, vs. yellow vs. red items in my RAID log and use that # in a chart on dashboard. I use a lot of countifs but I am not sure how to countif the health column. It shows a green dot so I want to count that as one green. Thanks for any help you can give. Best Regards, Christine
-
Formula to compare 2 cells and generate the difference on a 3rd cell
Hello all, I am working on a trainings tracker for our project team, and I am a bit stuck. I need to generate a formula that will compare the trainings that are listed in the Required and Completed column cells, and generate the difference on the Outstanding column. Any suggestions would be greatly appreciated!
-
Formula Question
Hello - I need help getting a formula updated. I have the formula I currently have in the row pasted below. I want to add IFERROR into it so I don't have a bunch of cells that say #INVALID OPERATION. How do I add that into the formula I have below? =[Session Date]@row - 25 + IF(WEEKDAY([Session Date]@row - 25) = 1, -2,…