-
Issue with printing when applying a filter
Hello all Hopefully not a naive mistake, but I have checked on previous Smartsheets I have set up and it is working perfectly But on the latest project I am working on, when I apply a filter, the print (then the consequent PDF that opens showing the print preview) is blank? there is no information apart from a heading…
-
Stuck on a due in 7 days formula
Hi all. I am stuck on a due in the next 7 days formula. Today is the 17th and I have a due date on the 20th. I have tried the following and kep getting 0. Many thanks in advance
-
Change the timeline view in Report widget
Is there a way to adjust the timeline view of the High Level Project Plan Report widget? Right now, it shows the gantt chart with a daily timeline - not exactly high level :) I would like this view to show one month per column
-
using ancestor to pull multiple levels of the tree structure
for example in this structure below I would want a formula to be able to pull the level 2-4 info into a column of their own for each level. I can get the level 1 easy enough using the formula: =IF([ancestor helper]@row = 0, [Task Name]@row, INDEX(ANCESTORS([Task Name]@row), 1))
-
How to use a predecessor without resetting the date?
For example, item 1 and 2 on a schedule. Item 2 will start while item 1 is still going on, but will get pushed back if item 1 gets pushed back. Anytime I use a predecessor, it resets item 2's start date to the day after item 1 is complete. However, item 2 will start before item 1 is complete. I need a predecessor to…
-
Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "Resource Totals" and I am trying to create conditions for the status column (Already made it a symbols column) for Red, Yellow, and Green Green = 0.9-1.1 Yellow= 1.2-1.3 Red = >1.3 =IF([Resource Totals]@row = "0.9-1.1", "Green", IF([Resource Totals]@row = "1.2-1.3", "Yellow", IF([Resource…
-
Re-Ordering Child Rows with Predecessors
When I drag a child row to re-order it among other child rows, its calculated date column (with predecessors) remains the same instead of re-calculates from the new order. In this example, it would be useful for the 10/03/22 date to automatically change to 9/29/22.
-
Open ticket report
Hello, We develop software. We are looking to create a spreadsheet with our open tickets. Is it possible to run a report on all open tickets we add to spreadsheet for daily review of open items? How would I do that?
-
Multiple Approvers, Different Cells
Hello, I currently have an automation that goes through 3 different sets of approvers, one after another. In the automations, I have assigned a specific person to approve after the last... But what I need is for the approval request to go to all 3 people at the same time, and their response recorded in their own column.…
-
Automation Delay
Hello, without going into too much detail, I have an automation that triggers when certain data is collected from a form. I am noticing, with this and other automations that I have worked on, that there seem to be delays in running the automation when triggers are reached. If I select run now on the sheet or a particular…
