-
Calculating HH:MM
I saw a discussion with @SteCoxy , @Paul Newcome , @Shawn Harris where formulas were built to calculate duration all the way to FPS. I only need the HH:MM and would prefer [H] and excel where the hours calculate total along with the Minutes. I saw a couple of formulas but none that just calculated the "IN" HH:MM against…
-
Formula Error - Counting Prior Month Numbers from Different Departments
Hi... I'm trying to capture information from 2 different references and the formula below is giving me an #incorrect argument. The formula will work if I remove the second reference which is giving me the total for items created prior month for the entire sheet. However, I need to break down the totals by different…
-
Trying to Auto-Populate a symbol if another cell is blank
My goal is to make it so that if a cell in column 2 is blank then the column 1 of the same row auto-populates with the Grey Circle symbol, any help is appreciated :)
-
Hi Community, report not update
I got the formula below, but not updating and keep going back 0 =COUNTIFS({Operations Report Range 1}, AND(IFERROR(MID(@cell, (FIND(":", @cell) - 2), 2), "") >= 13, IFERROR(MID(@cell, (FIND(":", @cell) - 2), 2), "") <= 16), {Operations Report Range 3}, AND(WEEKNUMBER(@cell) = WEEKNUMBER(Date@row), WEEKDAY(@cell) = 2)) I…
-
What am I doing wrong - SumIf referencing specific cell
This is my formula =SUMIFS({Time in hours}, {QA}, [Primary Column]@row, {Task}, $[Column3]$8) It works perfectly in the first cell of the column but when I try to turn it into a column formula I get an error of the syntax isn't quite right. No matter what row in the column my formula is in I want it to reference Column3…
-
Getting NETWORKDAYS to Work with Due Date Comparisons
Hello everyone, I am using Smartsheet to capture a bunch of data for vendor project tracking. I'm adding a few helper columns to compare some dates so I can evaluate performance and trends. However, I seem to be having trouble with the data for one of these helper columns so hoping to share what I've got to see how I've…
-
How do I calculate total business hours of operation in a week
Hello, I am trying to figure out how to calculate the total business hours of operation in a week. Basically if a site is open from 7am to 7pm Sun-Sat what are the total hours of operation for that site. I am new to Smartsheet and I'm having trouble with this. Here is a screen shot of the sheet. And I have attached it.
-
SUMIFS Formula Help
Hi there, Super stuck on how to get the below working, any help/advice about where I am going wrong would be greatly appreciated. Smartsheet 1 - Data Sheet, where: Range 1 = Dropdown list column Range 2 = £ value Range 7 = Contact Column Smartsheet 2 - Summary Sheet, where I am building formula (hence the References above)…
-
How do I count an occurrence when two dates don't match?
Hello, Can someone help me create a formula that will look at the form created date (date only) and compare it to the activity date being reported and tell me how frequently the activity date is not the same as the created date? I get invalid operation with the following: =COUNTIFS({NS FSE}, [FSE Name]@row, {NS entry date}…
-
Text to Text Formula Help
Good morning, I'm looking for a little assistance. I want to create a formula that will change text in one cell if the word is in another cell. For instance, if I have DOG 246 in one cell, I would like the other cell to input DOG, however if the first cell has CAT 123, I want the other cell to input CAT. Any assistance…
