-
Frustrated: Found formula for calculating time here in the community
So i found this formula and it is giving me #unparseable. Not sure what I'm doing wrong: =INT(SUM@row)+":"+IF((SUM@row - INT(SUM@row))*60<10,"0")+(SUM@row - INT(SUM@row))*60 I have 3 columns: Start End Total Hours 08:00 13:00 I'm using military time and I need to calculate total hours. Please let me know what I'm doing…
-
Converting Military time into standard 12 hours
Hello I am pulling data that comes in as military time and I need to convert it to 12 hours. Does anyone know how to do that? Thank you!
-
Using templates vs sheets in "template set"
Hi, I am creating template "sets" similar to what SmartSheet has created so that our workplan has the same related reports and dashboards for every project. Because we have a lot of users, I like the idea of having the main workplan in a template so that it cannot be overwritten. However, I noticed that in none of…
-
Possible to automate new rows in a sheet to be child rows if a cell value matches an existing row's?
To elaborate, we have a setup currently with our source sheet that creates a new row into the target sheet with Zapier, triggered when a PO# gets manually added to its PO# column. However, in some cases, the PO# that is added to a row on the source sheet is already on an existing row on the target sheet, and we want to be…
-
Filtering Columns in Reports
I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the other data. 1) How do I restrict the datas in the columns that have to be shown 2) If out of 4 child rows, 3 pertain to one…
-
Formula stopped working
I have a formula that was working and all of a sudden stopped working but no changes were made other than new rows added. The formula looks for duplicates in either the employee name or employee ID: =IF(OR(COUNTIF([Employee Name]:[Employee Name], [Employee Name]@row) > 1, COUNTIF([Emp ID for duplicates]:[Emp ID for…
-
Nested SUMIFS each with multiple criteria
Hello, Diving right in to the problem at hand. I have one sheet that handles reagent requests from multiple departments and another sheet that contains all of the stock solutions these reagent requests are made from. I want successfully created a formula that works for 1 sumifs scenario. =[Request Vol (ml)]@row -…
-
To Pull a recent status from another sheet
Hi Hope you are doing well. I have one sheet "Sheet 1", in which we have 2 fields that will be filled through the form. One for scanning the barcode of the Product and 1 for updating the status of the Product Process for ex- Raw material at the warehouse, Raw material in the manufacturing process, etc. In the 2nd Sheet, I…
-
Solved: Subtracting time using formulas
Published Time of Day Conversion and Calculation sheet https://app.smartsheet.com/b/publish?EQBCT=6d765f7f8a864676b3b5d5f8fd866bf1 Original "Subtracting time using formulas" thread https://community.smartsheet.com/discussion/3795/subtracting-time-using-formulas @Shawn Roberts @J. Craig Williams I searched for "Subtracting…
-
A couple countif formulas
I have a couple formula questions: I want to count the number of employees hired from 1/1/21-until today (and have it update to be today in real time moving forward). So far I have =COUNTIFS({GB Users Source Sheet Range 1}, @cell = "Active", {GB Users Source Sheet Range 5}, "Full Time", {GB Users Source Sheet Range 4}, I…
