-
Report Builder and Sheet Summary Report - Auto add new sheets
I successfully use the Sheet Summary Report - however, when I deploy a new Workspace, I must manually go back to the Report Builder and add the sheets that I want included in the Sheet Summary Report. Ideally, a Sheet Summary Report would look through ALL sheets, given my chosen criteria and return the results I'm lookingβ¦
-
If than statement
Hello, I need your help. I would like to use If statment in conjunction with symbols. The following is the statement that works only , got blank, green and yellow , but I cannot get it to work for red. =IF(ISBLANK([2019 Budget to Forecast Variance %]50), "", IF([2019 Budget to Forecast Variance %]50 <= 0, "Green",β¦
-
Inconsistent Horizontal Column Alignment
Is anyone else experiencing a problem where new records entered into a Worksheet sometimes aligns the text horizontally at the top of the row, and other times at the bottom, or center?? I can't find any consistency in some of the columns, even if I've set the entire row to align top, or align center, or align bottom. Anyβ¦
-
Changes to permissions for unlicensed users - View cell history
I just received notice that Smartsheet is making changes to its permissions for unlicensed users. While I agree with the spirit of the changesΒ (although it's not exactly clear what's changing, only how collaborator permissions will be on 9/19), what I do recognizeΒ and have a huge issue with is the decision to remove theβ¦
-
Cell History Restricted to Licensed Users
Based on the just released announcement regarding changes to permissions for non-licensed users it looks like the ability to view cell history will be restricted to licensed users. This is a common function used by all of our team members. It enables us to keep just the most recent status update comments visible in a cellβ¦
-
Disable sharing with free collaborators
For sheets owned by licensed users, is there a way to disable sharing to free collaborators (i.e. only allow sharing with licensed or non-licensed users), either on a per-sheet basis or at the account level (i.e. for all sheets owned by licensed users). Also, I think it would be very helpful to add a "user type" column toβ¦
-
Summing hours worked based on date criteria
I have reviewed the threads related to this but am currently getting an invalid value error when attempting to sumΒ a column based on a date range. Here is what I have =SUMIFS({Ford Chicago Accounting Range 1}, {Ford Chicago Accounting Range 2}, @cell < DATE(2019, 16, 8)) Where Range 1 is the hours, Range 2 is the dates,β¦
-
Creating a bug burndown dashboard in Smartsheet
Hello, We are currently using the SmartSheet + JIRA connector which allows us to export JIRA stories to SSheet and have bi-directional editing capabilities of both sources of data. This works great and allows team members (like our QA team) who do not have JIRA accounts to update their SSheet and the changes areβ¦
-
Ability to Create Order Form
I have search through various posts but can't seem to find exactly what I am looking for. I want to replace an excel sheet with smartsheets for demo order requests from the sales team. The existing excel sheet has a drop down of all the options that you can choose from and once you choose an option, it will auto-populateβ¦
-
Copy/ Paste Cells With Multiple Lines Doesn't Work
I've been digging through community for resolution to this issue, but I'm coming up empty. I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Excel (and Smartsheet). Currently, when I try to copy and paste these "multi-row" cells, they spill into separate cells insteadβ¦
