-
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…
-
If bringing numbers into Sheet Summary by a formula - need to be able to make less then 0 Red
If using a formula to get Sheet Summary data - for numbers, need to be able to make less then 0 Red
-
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…
-
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…
-
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…
-
Using formulas to populate the sheet summary, would like negative number to be red
Is there anyway in the sheet summary to have a negative number coming in by a formula to be red?
-
Help with formula for Current, Next, Last week calc based on date
I admit.. I'm gonna be lazy on this one. lol. I'm brand new to smart sheet. We have a field called [Due Date] that is a date type field. I want to create a string field that follows this logic: IF [Due Date] occurs during this week THEN "This Week" ELSEIF [Due Date] occurs next week THEN "Next Week" ELSEIF [Due Date]…
-
CHECK BOX IF TWO CELLS MET THE CRITERIA
Hello, as you can see, I have a form and if a employee selected a certain date and certain time, what is the formula to tick or check the box on the circled part of the picture. Please share with me the formula. Thank you
