Conditional Formatting - Not working for updates / new cells
All of a sudden conditional formatting (colors) of cells when a specific list option is selected on a cell update or when a new row + cell is created. The conditional formatting rules are working for existing cells, but not for above. I've tried deleting the rules and re-creating them, clearing formatting in the column,…
Smartsheet and the Elusive Roadmap
Dear Smartsheet users, A few months ago, we made the decision to remove our public roadmap, which has caused frustration for many of you, particularly in our Smartsheet Community. We removed the roadmap for a few reasons - as priorities and resources change, we couldn’t give the expectation that the roadmap was set in…
Resource management..... what is your idea?
Hi, I turned of resource management, i don't know how you guys see this working the way you implemented this. Sure the idea of one view is logical but my people work different hours, some 4 days 9 hours, some 3 days 8, etc. I tryed to make it work but it is just not possible without allot of extra steps. If you have a way…
Charts and Sights
Is there a way to get a Smartsheet Chart in a Sight?
Bug?: % Complete report filtering
Is this a Bug? I've set my report to display rows where %complete is "less than 100 or is blank" but the report continues to pull rows that are set to 100. This behaviour seems to be consistent in all my sheets, including this brand new one I created from a template!
Auto pre-populate a web form
Good day, I would like to pre-populate a smartsheet form with values in certain columns. I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text. However, I want to avoid having to create each URL by hand, this will take forever. Is there a way to automatically generate the…
CountIF formula for two different columns??
I'm looking to find a way to create a count statement if one column contains "a" and the other column contains "b". Example: If "Status" is "Open" and "Issue Type" is "Bug",then count # I looked to the formula example sheet for this but all I see in one that I believe would work has a "expand rows to see example" message…
greater than or equals to
i need to activate a check box based on the following condition. if date cell A is less than or equal to Todays date and cell b and greater than or equal to todays date then check box. how do i write this please as i can get the formula to work all but the equals to bit. ta blair
Hello, I am wondering how to choose a range on Smartsheet that will go on forever? Please advise.
Deleting update requests
I have a sheet for meeting action points and use update requests to keep on top of oustanding actions and mark and action complete when it is done. I have been trying to delete update requests on completed action s but have found you can on some and can't on others (the delete drop down is greyed out). There appears to be…