-
I need help with a formula, I need it to return a blank cell.
I have the following 2 formulas: =IF([Rental Period]3 = "Daily", VLOOKUP([Scissor Lifts]3, {Scissor Rates 2}, 2, false), IF([Rental Period]3 = "Weekly", VLOOKUP([Scissor Lifts]3, {Scissor Rates 2}, 3, false), IF([Rental Period]3 = "Monthly", VLOOKUP([Scissor Lifts]3, {Scissor Rates 2}, 4, false), ""))) =IF([Rental Period]1…
-
Countifs #INCORRECT ARGUMENT SET
Hello, I'm trying to get the following countifs function to work but I'm getting the Incorrect Argument Set error: =COUNTIFS([Employee Name]:[Employee Name], "Name", Sunday:Saturday, "W") For context I'm trying to count the number of days specific employees have worked YTD.
-
COUNTIFS and SUMIFS with a Date Range
Hello, I'm trying to count the number of cells that have a date in the year 2020. This is the formula that is returning "0" which is incorrect: =COUNTIFS([Column 1]:[Column 1], <=DATE(2020, 12, 31), [Column 1]:[Column 1], >=DATE(2020, 1, 1)) Additionally, I want to sum the values that correspond to this date range, and…
-
Children from a different column
I'm working on a stock inventory program for my company. The Parent row is the Running total, min/max barcode, description and so on. The Children will be the stock coming in and going out. I can on the Parent row Sum Children in IN column an then Sum Children in OUT column them have the formula in Parent Stock cell…
-
Status corresponding to % Complete
I would like to figure a way for the Status Column to auto fill depending on what the % Complete says. For instance: 0% = Not Started 1-99% In Progress 100% - Complete Conditional Formatting is not the way to go and I can't figure out the right If/Then statement to use. New to this world so don't think down on me too much.
-
Is there a way to return the row location of all instances of a duplicate value within a column?
I've created a duplicate flag column using the following formula: =COUNTIF(Email1, Email1) + " of " + COUNTIF(Email:Email, Email1). This shows the instance and the count. What I would like to be able to do is provide the row numbers of the duplicate emails. Match will only find the firs duplicate but won't return all of…
-
Consecutive Count of Children
Please help. This seems like it should be a fairly simple answer, but I’ve worked on this for hours with no success. I would like a count formula that counts the Children, and numbers them consecutively. I can then use an embedded IF statement to calculate specific hours attributed to each Child. This simple formula,…
-
Calculating Total Working Hours between Sign In & Sign Out
Hello, I'm facing difficulty of summing up Total Working Hours in the worksheet. I'm working on calculating a simple total working hours for my employee, they just fill in Smartsheet form then the worksheet will calculate it. I need help on which solution work best on this project. Below I provide the details: Employee…
-
Flag if date created > 48 hours and completed column is blank
Hello, I'm new to using SmartSheets and first time poster here. Hoping you can help me with an elegant solve? I'm trying to create a function where a row will be highlighted when it satisfies two criterias: 1. if the date created has been more than 48 hours 2. and completed is blank (not marked with a date) Basically in…
-
Formula to include verbiage based upon selection
Hi all, I am working on a sheet in which I need a formula that when a status is selected in one column that additional verbiage would pre-populate another column. The picture below in the status column, when I select the word "cancelled", I would like the comments column to show the word "event is not going to happen" I'll…