-
How to return only the most recent entry before a targeted date range?
Hello, I currently have the following asset booking sheet: What I'm trying to do is, for the column 'Assignee in Possession Before Your Booking Date:', if the asset is available within the booking date range that the user has entered -- I would like the column to display what assignee will have the asset last (most…
-
Auto Add or Remove Sheets from Report
Hello, I am creating reports for individuals with multiple sheets to review. I see that I can click on a folder to include all sheets in that folder under the "Where?" section. Is there a way to automatically add or remove a sheet from the report if it has been added or removed from the folder? I keep having to manually…
-
Timeline end date not updating correctly - help needed
Hi, I'm having an issue with my end date at the top not updating correctly. I have all the subtasks below indented correctly; however, it will not reflect that at the top most level. Please see the photo attached. I added in a new line at the bottom with an end date of 03/09; however, the date at the parent task refuses to…
-
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
