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. Archived 2017 Posts
Archives for June 2017
Discussion List
Deleting a Report Item also deletes it in the Sheet?
I came across an interesting interaction today while editing a report. When I went to delete an item off of the report, the item itself also disappeared from the sheet that it was associated with. Is there any way I can retrieve that information and have it back on the sheet but not the report?
New Data Validation feature almost works...
Well I was excited to try out the new data validation feature until I realized that you can't put formulas in validated blocks either. So in a Date column, I can enter "6/2/2017" with no problem but if I enter =TODAY() I get a warning. Could we get that fixed?
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
Publishing Gantt Chart
We have a Gantt Chart, we have many columns for various items and the standard Start/Finish/%Complete....... We don't want to share the sheet with a lot of people they don't need all those extra columns, we really just want to show them the Primary/Task Column and the the Gantt Timeline that is it. Is there a way to…
Breakthrough...
After 6 months of internal debate and resistance SS is finally taking hold, colleagues want to get involved and more process is heading the SS way...I feel like running round the park naked!! Thanks Smartsheet
Why Publish?
What are the benefits of publishing sheets and or reports? What are the negatives of publishing? Thanks!
Admin Access to Everything?
Is there a way that a Smartsheet Administrator would be able to gain access to all sheets/workspaces, even if not specifically shared to the admin? I am asking in terms of access controls, so we can put a control in place where the admin ensures no PI or Confidential informaiton is being added. Thanks!
Conditional Funding
Would there be a way for me to add my second and third columns based upon the conditional formatting of the rows? the conditional funding only depends upon one variable.
SUMIFS formula
I'm trying to create a formula that adds my second and third column if the fourth column says "LOST" , I want that same formula to subtract the second column from the first column if the fourth column says "KEPT". -My column titles are: Column1: total budget Column2: money allocated Column3: tentative remaining Column4:…
Formulas
I would like to have a nest If / Then formula that is dependent on the %Complete Column. EX: =IF([% Complete]9 = 100%, "Complete", IF([% Complete]9 = 0%, "Not Started","Pending")) I am getting the #UNPARSEABLE error. Thanks in advance.