Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
How can I count just Blank child cells?
I can make the formula work if the cell has a number in it but not if it is blank! I've nested IF statements until I'm blue!!!
Column name/header
Feature request It would be great if I was able to format my column name/header. Specifically to wrap text so I can see the entire label for narrow columns.
Predecessors without adjusting date?
I've searched the community/help and haven't found a good solution so I'll ask here. There are tasks that have proposed start and finish dates. I have a duplicate task that will show what the actual start and finish dates are because of delays and such. Currently the duplicate has the same start/finish as the original and…
If/OR formula
I can't see where I went wrong; I am trying to get two columns to calculate the number of days between two dates when one of the fields is "N/A". Here's what I have so far: =IF(OR([Initial Approval]1="",[Request for PR]1="",[Initial Approval]1="N/A",[Request for PR]1="N/A"),=(NA(),[Request for PR]1-[Initial Approval]1+1)…
Dashboard Add-On Change
As new Smartsheet users we were excited to start implementing Smartsheet and had plans to use the Dashboard. It is disappointing to learn without warning that the Dashboard has been removed and will be an expensive add-on for Team licenses. Was anyone else aware this was happening? Will you just plan to get by without the…
The predecessor changes the start and finish dates
Hello, I'm creating a construction schedule. I entered all my start and end dates which automatically calculated the duration. The problem is, when I enter a predecessor, it automatically changes the start and finish dates; why is this happening and what can I do to stop it? Thank you.
Count IF multiple criteria
Hi - I would like to have a formula to count items based on a couple of criteria - Status and Deliverable. I have attached a picture of the columns.
Gantt charts - tracking date changes
hello! i know that i can track date changes in any cell by looking at cell history but is there a way that i can overlay a new gantt on the original gantt to illustrate how a project might have evolved/slipped?
include TIME in the column properties
Hi Smartsheet, Is it possible for you to add Time column property?
Automate Value Recording
All, I am trying to setup a PMO dashboard where I am putting Total Portfolio Value graph. I have to update the graph fortnightly to record current value. Is there anyway to automate this function so that everytime I dont have to manually enter value.
