-
How to enter a formula referencing other cells within Duration?
Hello, I have a column where I indicate the budgeted hours available for a task. Within the Duration cells, I would like to enter a formula that takes the budgeted hours, divides them by an efficiency factor and yields the resulting duration available for the task, however, I'm unable to enter any formulas into the…
-
How to reverse the order in which a range is counted?
Hello, I have the following Smartsheet: In this Smartsheet, I'm building an asset booking system and, for the 'Asset Available During Your Booking Date Range?' column, it displays whether the particular asset is available for the date range inputted by the user. My formula is as follows: =IF(IF([Asset Booking Start…
-
Is it possible to suspend all automations for a row based on status?
I have a SmartSheet with numerous automations based on the Status of the line item. One of the Status options is to put the project on hold. Is there any way to halt/suspend notifications and other automations if the status is on hold?
-
I need to add the number of days in one cell to start date and it needs to be in workdays
I have one column with my start dates and a second column with a varying number of days that need to be added to the start date, and I want the resultant date to be in workdays. I have tried various formulas and have not been able to find one that pulls the value in the second column to add to the start date. Suggestions?
-
How can I subtract the hours worked from total allotted hours?
I am trying to track the total hours worked for an external vendor. We are paying for their service for a certain number of hours and each week I want to subtract the hours worked for that week from the allotted hours. I want a cell that gives me the total and subtracts out hours worked. I cannot, for the life of me,…
-
VLOOKUP Will NOT Work on my Date Columns
Hello Community, I am losing it on this simple VLOOKUP formula, for some reason I am not having a value returned on these 2 date columns. My current formula for one is the following: =VLOOKUP([Site ID]@row, {Cabling Date Range}, 15, 0) The column is the 15th column in the lookup range but it is saying invalid column value?…
-
ISBLANK combined with AND statements
Hi, I'm having trouble nesting AND & OR statements with the ISBLANK condition in my IF statement. I have two columns: [Agreed End Date] and [Actual End Date] =IF(AND(NOT(ISBLANK([Actual End Date])), (OR(TODAY() - [Agreed End Date]@row < 1, "On Track", IF(TODAY() - [Agreed End Date]@row < 7, "Delay", IF(TODAY() - [Agreed…
-
Across 3 Sheets -> Count When Index Match (Cross Sheet from Sheet 2 to Sheet3) Equals Cell Value
I have 3 Sheets: Sheet1: Metrics Sheet2: List of Addresses (without States) Sheet3: List of Zip Codes and their States Without adding a column to Sheet2, what is the correct formula (to be placed on Sheet1) to count the number of rows on Sheet2 that have the same State shown on Sheet1? Sheet1 Data State | Count LA | count…
-
=IFERROR Issue
Hello, I have an arithmetic formula that sometimes gives me a number, and other times does not depending on if the [Completed Milestone by Month] columns are populated. When they are not populated they result in an error "Divide by Zero", which is fine. However I'd rather this not display on my dashboard. I've tried…
-
Due date formula based off priority
I'm trying to have calculate a due date based off the priority (high , medium, or low), add 1,2, or 4 days to the date submitted. I'm using something like the below, but getting an error. Any help? =IF([Business Priority]@row = "High"), [Date Submitted]@row + 1, IF([Business Priority]@row = "Medium"), [Date Submitted]@row…