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 February 2017
Discussion List
Can I view history of who set/removed alerts and when?
An alert was removed and we do not know how that happened. Has anyone else had this experience? Is there an alert history we can review? Thanks! Sheila
Report Builder Gantt Chart is off
I've been playing around with report builder, to create a summary page of all my sheets. I have a check box I use to filter the lines I want on the report, which are typically the first/top line, which is the entire project. The Gantt view in each sheet is correct, but in the report, every line has the gannt shifted by one…
Count Risks only when checkbox is open
I'm trying to create a formula that only counts the risks (High, Medium, Low) when the completed checkbox is not checked off. I have a formula for counting the number of risks (=COUNTIF(Risk:Risk, "High") + COUNTIF(Risk:Risk, "Medium") + COUNTIF(Risk:Risk, "Low")) but I have another column for "completed" that I want to…
Dynamic Hierarchy
I am in the process of developing some work flow sheets for my team and I would like them to do the bulk of their submissions via web forms. Is there a way to create dynamic hierarchy whereby when a form is submitted, x criteria places that new submission under the correct "Parent"? Let's say that I have 3 Categories…
What determines the country (currency) of a sheet
Prior to the latest release currency columns displayed as $0,000.00. Now it displays as CA$0,000.00 which adds clutter. All our computers have US as regional Settings. If I change my personal seettings to Canada the CA goes away but the date format is d-m-y and can't be changed to m-d-y, so changing the settings is not an…
Visual misalignment of highlighted row
Does anyone know how to get rid of the visual misalignment of a highlighted row on the screen. I am usually using Smartsheet on Safari. I tried to attach a screen shot of the issue.
Update request - can you use a formula to select which rows to update?
I'm working on plan "C" of my idea to enable users to update rows assigned to them without risking accidental changes to another user's row. The update request is a powerful feature, but it requires manually maintaining row selection. On our sheets, the rows assigned to a specific user will change regularly. I want to…
Can you give users edit permissions to a sheet but not have them view it?
I assume you cannot do this, but need to verify; I want to send reports to various users with only their rows so they can update their part of the sheet. This report would have edit permissions. I will create another report showing the entire sheet with view only permissions. In order to update a the edit report, they must…
Notification by Editors
Hi there Can a person that has a shared sheet as a editor.... make Notifications settings to other people?
Alerts when nothing changes
I know I can track/highlight changes and I know that I can set up an alert when something changes. However, is it possible to get an email alert when nothing changes? For example. If I was expecting a task to be completed on March 1st and the task owner did not update the status field on the project plan, can I get an…