-
Help with a Formula?
Hi, I am working on row of dates and I am trying to get the next due date (from today) in another column. I have tried a couple of formulas but get #UNPARSEABLE. What should the formula be? I am looking for the formula for the cell in yellow.
-
Formula Help - Works in Progress Based on Start and End Dates
Hello, I am working on a resourcing sheet to look at works in progress by the week. I have a sheet that has a column for each week of the year. I am working on a formula to reference another sheet which has a list of projects with the Project Manager and start and end dates. For each week of the project (the start week,…
-
IF AND based on an input + or -
I can get this to work and in my head it should :) I want an "In Spec" IF… the Stage 1 Temp Verification is less than or equal to S1 Temp minus 5 AND Stage 1 Temp Verification is great than or equal to S1 Temp plus 5. =If([Stage 1 Temp Verification]@row) <=([S1: Temp]@row + 5), ([Stage 1 Temp Verification]@row) >= ([S1:…
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
How to split the content of one cell into separate columns
I have a cell with data in this format: Approved,AAD:tammy.couch@transcoretech.com , 9/3/2019 11:06:50 AM I already have a formula for the Status Column, which is Approved. That formula is =IFERROR(LEFT([MFG Approval (archived)]@row, FIND(",", [MFG Approval (archived)]@row) - 1), ""). It works great. However, I need to…
-
IF Statement based on multi-value drop-down
Hello All, I have an IF statement that needs to execute a formula if True, and present a statement if False, typical I know. But I need this to work based on the multiple values that can be selected in an adjacent cell. I've tried IF CONTAINS or IF HAS and have not had success. Let me know if anyone has encountered this…
-
I need to calculate the estimated end date of a project based on working days
To calculate the end date of my project, I need a formula that would take today's date and add the number of working days left to it. I keep getting an Invalid data type error. The Today's Date column and my Estimated project finish date column are both set as Date column types. My Days Left column has it's own formula…
-
How to index /match that has multiple dates- but I want the latest one
I have read so many index/match, max/collect, and index /collect questions, and all of them seem to be just a little different than what I need, and I can't figure this out. So I have two sheets, one data sheet that I am pulling from based on criteria from another sheet. Except the data sheet has multiple entries and I…
-
Manpower Projection Formula
I have multiple schedules for different projects with the same base information: Task Name (Primary) Start Work Date End Work Date Duration (Dependencies are enabled) Manpower Needed Many tasks have durations that overlap with other tasks. I want a separate manpower projection sheet that tells me each day what the total…
-
Calculating a review date based on both the hire date and last date of review
So I've burned up about 6 weekends working on this, and have asked a few peripheral questions on it, but never just asked the whole thing. I met with a Smartsheet pro and he suggested I bring this to the community. I would really appreciate some help on this. I need a formula that will calculate the next review date…