-
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.
-
Formula with range data
Hello, I'm looking to see if anyone knows a formula that would add owner income and co-owner income together to reflect in Joint Income column. I'm not sure how to do this with data in ranges. Thank you.
-
New entries to the Smartsheet don't include formulas
Hi all, New entries into my Smartsheet are not including the 2 formulas I have created. I have tried the troubleshooting which advised the following: Ensure the formulas are present in cells near where you want the new rows to appear. Check if the last row before the new entry is indented, and remove any unnecessary…
-
Formula for Resource Type, Resource Name and Year
Hello - We have set up a sheet to pull from a Master document to include Resource Type, Resource Name and Year. The Year is from a Helper column. Can someone review the current formula we have to identify where we went wrong to no pull "zero" as the result vs the actual number. Before adding in the Help Year and Reference,…
-
How can I make FS dependencies start on the same date the predecessor ends?
Hi everyone, I’m migrating a schedule from MS Project to Smartsheet and I noticed a difference in how FS (Finish-to-Start) dependencies behave. In MS Project, when a task has an FS predecessor, the successor’s start date is set to the same day the predecessor ends. But in Smartsheet, the successor is pushed to start one…
-
SUMIFS Unparseable Error
Hi, I'm attempting to use SUMIFS to sum data (Royalty Rate) from another sheet if the Project Number in the other sheet (Project Num) matches Project Number in the current sheet, and if Based on from the other sheet is "SRP". Current formula that isn't working is below. =SUMIFS({Royalty Rate}, {Project Num},[Project…
-
Comparing names from Worksheet A to Worksheet B and Identifying those on A that are missing from B
I have two worksheets. Worksheet A is the master Worksheet B is a collection of months' worth of data-it is populated by a form. I'm trying to write a formula where I compare Names from Worksheet A to Worksheet B and identify on Worksheet A names that are missing from B in the current month. Worksheet B has a column that…
-
Cross-reference sheets to find matches
Hi! I am trying to determine how many of our students are later hired by our institution. I have a Sheet with a Student Name column , and would like to add a "Hired" Column in this sheet that would cross reference to a second sheet (Master employee list) and flag if there is a match in the Employee Name column (so if a…
-
IF OR formula for 3 conditions
Team, Struggling to get the below formula to work…any thoughts. (The cells contain numbers in text/numbers columns): =IF(OR([02/01/25]@row < [01/01/25]@row , [02/01/25]@row <> [01/01/25]@row , [02/01/25]@row > [01/01/25]@row ), "Down", "Same", "Up") Thanks
-
Formula for Multiple same names count once AND single name counted as well
I used this formula from another community post which counts a person's name only once if it appears multiple times in the column. However, it does not count a person's name at all if the name only appears one time and I need it to. In the example below, how can I get it to count Doe, John as one AND Mouse, Mickey as one…