-
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…
-
Nested IF AND formula
Using the formula below to determine the health of a project but I need to change it. Right now it is showing the health as yellow if STATUS is Not Started and there are more than 14 days between now and the forecasted end date. I would like for it to show yellow when the STATUS is Not Started and there are 0-14 days…
-
How to create pop up text in Smartsheet Dashboard
I am trying to creat an info icon so that when use scrolls over it, a pop up appears to explain the charts in the dashboard
-
How to indicate the Top5 from a smartsheet with Case-insensitive criteria?
Hello! This is my second question here. The community was incredibly helpful for the first one! :) - I want to pull the Top 5 Customers with more active projects from a project tracker (the user inputs project ID and from a data pool, the Customer Name and other info are pulled) to a dashboard chart. So far, I am using a…
-
Auto-populate vacation time in production timeline
I am trying to see if there is a way to automatically blackout vacation time specific to a person, similar to the way holidays are able to be blacked out.
-
Cross Sheet Formula with One Criteria
Hello, I am creating Smartsheets for quality assurance testing. Sheet #1 will be the test scenarios and steps taken. The row will include a drop down menu to indicate if the step passed, failed, etc. I need a formula that if "Fail" is selected from the drop down menu, the step's ID # will automatically pull into Sheet #2…
-
Calculate Average Time
Hi Team, I have one sheet that calculates the time duration that a tech is onsite per line, but what I need to do is in another sheet calculate the average time TOTAL for all entries. I'm having trouble figuring out how to accomplish this. Thanks in advance for everyone's assistance!
-
How I find the first column?
I have a range of columns with 14 milestones. If the milestone reached, then it will be delete and the cell is blank. Now I would know, in which column are the first date. As result I would need the column-name, with the first date or the number of column, counted from the first column of the range. Any ideas, which…
-
Input the date for a multi-select dropdown
Hi all-- I am trying to create an efficient way to track my samples as they move around to different facilities. Please see my screenshot for what I am working on. Ideally, I'd like to just have the check box as in the screenshot because it's easier and faster. Space on my SmartSheet is also a premium. Now, I'm aware that…
