-
Calculate duration between two times
Im looking for a formula to calculate difference between two times eg 08:00 - 10:00 should give a duration of 2 but running into errors. I have column types as text number. 08:00 is named Start Time and column for 10:00 is finish time
-
Collect cross sheet formula help
I want to pull through the task name in one sheet where the check box at row is checked into another target sheet. This is what I though the formula would be but I get #UNPARSEABLE as the error. =INDEX(COLLECT({Task name}, {Stage check box}@row , 1)) Um, help please?
-
Need to convert time entered to mountain time
Hello, I am working on a sheet where orders will come in across the country and list local time. I need to be able to convert this time to mountain time regardless of daylight savings time. Anyone have any ideas? Also is possible to convert to the time to military time if it is received in standard time? Below are my…
-
Formula to get the last child row and apply conditional formatting
I have a sheet conditional formatting has been applied so that Ancestor = 0 is one color, Ancestor = 1 is another. Ideally, I'd like to apply conditional formatting so that all rows with Ancestor = 2 are conditionally formatted to the automatic format style except for the last row which will be a different color. I'm still…
-
What formula can I use to update the data based on a change in 1 cell with the date?
I have searched far and wide for a formula that may help me achieve what I need, to no avail. I have a data table that is updated weekly to showcase upcoming launches based on their scheduled launch date. I currently manage this in Excel but the data is currently on a Smartsheet grid. Ideally, I'd like to build out a…
-
Assistance Appreciated
Hello, This one is a bit tricky. I need to create a formula that will look at 4 columns in a row. If text is in any column in that row, based on the column the text is in will need to be text added to the 5th column. The words to enter into the LICENSE CATEGORY FORMULA column will be one of these 4 words: PHARMACY,…
-
if statement based on another column
Hello All, I am trying to figure out the best way to create an if statement. In my column RML Status if the status is RML-Current or In-TRL Current I would like my helper column to state ACTIVE. If it doesn't have either of these two status', I would like it to state INACTIVE. How would I go about creating this the…