-
Formula for calculating total time between two military times
Building a 'time tracker' to calculate total hours worked. Can someone help correct my formula(s)? I'm using formulas found in this community but I might not be using them correctly. I'm expecting the Hours column to display "10.71" not "109.72". Clock in Time: =RIGHT(Created@row, 8) Clock In (Military):…
-
Why is my INDEX MATCH formula breaking after 2 rows?
Hi, any help with this will be hugely appreciated :) I have two sheets, both have 2 identical columns, a unique identifier and a date column. There are 5400 rows on these sheets so I was hesitant to copy and paste as I will not be able to check each one individually and of course would prefer this automatic setup for…
-
Multiple sheets, multiple criteria leading to a date being copied from one sheet to the other
I have two sheets that I am using for this issue. Sheet A is a form intake sheet where individuals answer several questions and upload a file/report. That report is then reviewed and, if determined to be complete/accurate, I select "Approved" in a drop-down box (Column named "Approval") on Sheet A. On Sheet B, we have 500+…
-
Formula error
what is wrong with my formula? I've tried different variation but always getting #Unparseable error =IF(P2F_status_1Q2024 Range 1 = "Promo", P2F_status_1Q2024 Range 4) =IF('P2F_status_1Q2024 Range 1' = "Promo", 'P2F_status_1Q2024', Range 4) =IF('P2F_status_1Q2024 Range 1' = "Promo", 'P2F_status_1Q2024' Range 4," ") What i…
-
Not sure which formula I need...
I am trying to pull data from the ISIR Pull 2023-2024 sheet and make it populate the information into another range on another sheet. I want the ISIR Pull 2023-2024 sheet to match the Student ID to the Jones Scholarship sheet and pull in the FA23 HRS without having to hand-type it. (Work smarter, not harder, right?) The…
-
Average Collect with OR
Hi Smartsheet Community! How can I work OR into this Average Collect formula? I need the "C&P Complete" reference to be "Yes" OR the "Does this position require credentialing?" reference to be "No" worked in. =AVG(COLLECT({Days B/T Submission & Onboard}, {Provider or Non-Provider From Req Sheet}, "Non-Provider", {C&P…
-
Find last Combination and Return Date
Hi I want to be able to find a previous combination of an entry and return the date for that entry (not the created date, but the date in the date field) I've been using the following to find the highest previous date but I want to integrate an extra criteria which is the last time a certain combination appeared.…
-
How do I reference a Report Summary Field into a formula
I created a Sheet Summary Report for one of my Sheets. The Sheet Summary Report is grouping by JOB NAME and giving me MAX values for certain criteria I have a metric that is calculating a RATE and I do not want the MAX value of this rate in my sheet I only want the rate for the row in my sheet that has the 2 MAX values.…
-
Conversion
Hello, I have a drop down list in one column, and based on what is selected in that column. I would like my data to convert based on information in another. I have tried Vlook up and If statement but have been unsuccessful. For Example, if someone selects 5347550 on the form, I want the column on the sheet to convert to If…
-
Workaround for countif miscalucating unchecked boxes in column
Looking for any advice, guidance, on calculating unchecked boxes. I would like to use summary data and post to a dashboard for review and status of how many unchecked rows. However, it counts the added/unused rows at the bottom of the sheet showing an incorrect calcuating of unchecked marked boxes. We add rows to the sheet…