-
How to include a cell value name in my automation list
To setup automation, the trigger part works perfectly fine. However, the response is to change the cell value, but the cell name doesn't appear in any of the options.
-
Attaching files to Columns?
Is it possible other then the rows attachment field, is it possible to set columns to attach files?
-
If statement in parent row to delete children row?
I am working on a sheet where a task is to validate a set of data. If the data fails there is a follow up task to revise, if it passes the next task is to launch. Right now I have these all set as rows. But I wanted to see if there was a way to insert a checkbox for pass/fail and then based on whether that pass or fail…
-
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…