-
Trying to Clear a "Ball in Court" cell when item is complete
Help! We are trying to set up a formula to clear the "Ball In Court" when a line is complete. I know that you cannot format a formula in a contact cell, but there has to be a way! It's appearing as though work is still needing done and it is not plausible to remember to clear the cell each time something is complete. Any…
-
Returning Data with a formula
Boy have I gone round and round with this! This formula is meant to bring back the data from another sheet based on the code entered (ie: code - CALVE and it should return the full name, email of that company from a different sheet). Sometimes this formula works perfect and other times it brings back the wrong company? Can…
-
Inconsistency with FS Predecessors
This might be incredibly simple but I can't seem to find it already answered! Sometimes when I set a Finish to Start predecessor, the auto-filled "Start Date" is the same date as the predecessor row instead of the following business day. This seems to happen only about half the time. I've attached an example of me having…
-
How do I return a value, based on a date, between dates? (versus week numbers)?
I am trying to return a value to a cell, based on a date condition at the top of the column. For example, if there were 52 columns of the "week dates" in a year. The parameter for the return value is IF the date condition falls between a start date and finish date. I have been able to do this when I convert all dates to a…
-
IFERROR
HI all, I have a sheet where I am collecting data. One is our overall variance. In certain rows I do not have data and receive the #DIVIDE BY ZERO message. I have attached the screenshot to show my formula. Thank you,
-
Cross sheet formula - Reporting by week
Hi Again! Is it possible to create data that provides QTY of selections checked per week and record this on a sheet automatically with formula. So we are managing live installation projects, with a high turnover of projects. Our main sheet is called PROJECT MILESTONES where we track all the live project activity. Within…
-
Determining duration in Hours:Minutes
Hey guys, I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning: 1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified (Date).' 2. I created a…
-
Can Smartsheet Handle Shifts (Different Working Hours) for Scheduling?
Looking at using smartsheet as a scheduling tool for our project (heavy construction) as it is more mobile friendly than say an MS Project or P6, and the gantt charts actually work as opposed to airtable which has a great interface but their timeline "block" is garbage. We work 2 or more shifts with our crews, so I need to…
-
Multiple If Statements
I have found quite a bit of useful information to make Nested If statements; however, they are set-up to be "if this, then that or if this, then that". What I need is: "If this is equal to this, and this is equal to this, then this" Here is what I have come up with: =IF(AND(Firm2 = {Building Code}, Firm = {Firm},),…
-
Issue with COLLECT and duplicate dates
We are trying to achieve a formula that finds the most current Tracked task's Variance from the Baseline date. Tasks are arranged in a table/schedule in step by step order. I'm having an issue with this formula here: =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task…