-
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…
-
ISNA Excel Formula
I am trying to recreate an excel formula in Smartsheet that looks for the column Header word in the proceeding columns within that same row. If it finds the word in that row, it then places the word in the cell that the formula exists. So if the formula is in [Apple]1, it searches a specific range of columns in row 1 for…
-
Can you auto populate task dates based on the entire project end date?
I have different marketing tasks where their completion dates revolve around an entire projects completion date. For example, there are tasks that need to be completed 10 days before project completion date, 20 days prior, 30 days prior, etc. Is there a formula I can use that auto fills task due dates based on the project…
-
Complex formulas ammendment
Hi All, I have an existing Smartsheet that has some relatively complex formulas to count the the status of an action as there are several conditions for an action to show as "Open" and "Overdue". Over the last few days, we have modified the sheet further by adding columns and each added column now comes under as added…
-
The 25,000 cell reference limit is puzzling
Dear Smartsheet: I am a bit confused by the 25,000 cell reference limit. In my specific case I am simply trying to VLOOKUP from a table where I have 700 rows and 17 columns. That equals 11,900 cells which is less than 25,000 cells. So, why am I getting this error? It creates an incredible amount of frustration and…
-
Multiple IF/AND for duration and status
Hi Community, I am trying to structure an IF/AND formula to reflect the following conditions: IF [Duration]@row <> 0, AND IF [Complete]@row =0, "Not Started" IF [Duration]@row <> 0, AND IF [Complete]@row =0, AND IF[Complete]@ previous row = 1, "In Progress" IF [Duration]@row <> 0, AND IF [Complete]@row =1, "Complete" IF…
-
Locking a Formula in a Column
I created a formula in a column that I do not want people to be able to change, but to still function as people add new information in the rows. By locking the column, will the formula still work (the cell will still populat/update) when the reference cell in the row is updated?
-
rollup formulas
I have personnel sending out emails. I want to track how many total emails each person has sent in a given city they put a checkbox after each email has sent. I would like a formula that would total the checked boxes from each person. is that a countif? countifs? thanks, SGF