-
IF formula to calculate points
I'm trying to create a formula to calculate points and I can't seem to get it right. This is what I have: =IF((Occurrence@row = "Tardy", 1), IF(Occurrence@row = "Late", 2), IF(Occurrence@row = "Half", 3), IF(Occurrence@row = "Full", 5),0) Basically, if the Occurrence column has any other those, each is worth a specific…
-
Formula for counting total of a specific word in a parent column only (not including child)
Hi everyone, Is there a formula to count the total rows of a parent row (instead of making a checkbox section for parent row)? Need help with this the most: Is there a formula I can use in summary sheet that can help me find the total count in a different sheet for a specific word (Ex: "NC", "FCAR", "total of all the…
-
Set checkbox color based on the color from another sheet
Source Sheet: JOB TRACKING Reference Sheet: JOB NOTES {JOB NOTES Range 1} is the SALES ORDER column on reference sheet Unique identifier: SALES ORDER I'd like to check the Shipped box in the JOB TRACKING sheet by line if the SALES ORDER color in the JOB NOTES sheet is green. I'm stuck here: =IF(INDEX({JOB NOTES Range 1},…
-
Can someone please help me with SUMIF formula?
I am trying to use a formula that will add value in children cells when cells do not include an asterisk in front of the value. Basically, I am creating an invoice tracking spreadsheet and I want to be able to input expected monthly invoices (based on the contract) on the front end, but not have those values added to the…
-
Count if greater than 0 returning a divide by zero error
Hello everyone, I am trying to count in a sheet the number of items greater than 0 and it is suddenly giving me a divide by zero error. This formula had been working but is now broken. Help, please. Formula: =COUNTIF([% Paid]:[% Paid], Also tried =COUNTIF([% Paid]:[% Paid], ">0") Keeps returning not sure why. Can anyone…
-
formula works fine in individual cells but can't be converted into a column formula
Hello, I'm calculating the attendance with this formula (where {date} is a reference to a different sheet that should match a date in a cell), and it calculates correctly in individual cells, but when i'm trying to convert it into a column formula, i get a message that the syntax is not quiet right. What is a problem here…
-
Referencing list
So we are using smart sheets for Behavior Based Safety observations I have a sheet that has a total by employee I want the employees to enter their ID number instead of their Name and it auto populate their name on the sheets. SO Employee will fill out a form and submit their observation. Instead of entering their name…
-
Index Match another Sheet
Hi there, I need help with structuring this formula: =IFERROR(IFERROR(INDEX({Program Duration}@row, MATCH([Program Name]@row, {Program Name}@row, 0)), INDEX({Program Name}@row, MATCH([Program Name]@row, {Program Name}@row, 0))), "") I want to index match column information to another sheet. The column names are the same…
-
Stacked Bar Chart Data Sheet
Hello I am trying to create a stacked bar chart based on the following: I have a multi-select dropdown column, so there may be more than one value in it. I then have a second column with Priority listed. I have created a sheet that calculates how many times each drop down is used but I want to know how each drop down…
-
If Contains Formula
Hi there, I need help with putting together these 2 formula's: If "How does the Company make money or plan to do so?" selection does NOT include “Other” then show below: [Name of Company] makes or plans to make money through [Other] If "How does the Company make money or plan to do so?" selection does include “Other” then…