-
Portfolio Reports
Hello! Has anyone run into an issue with Portfolio Reports similar to the below and has a suggestion? We have a portfolio report set up based on the portfolio and it is bringing in sheets automatically based on the templates we have in the portfolio. Whenever we log out of Smartsheet and log back in, the report resets…
-
How to trigger an action from one Smartsheet to another
I'm working on 2 Smartsheets right now and am trying to create a formula between the two. My first Smartsheet document is called "Stores in Progress." The 2nd Smartsheet is called "Ready for Service." In my "Stores in Progress" Smartsheet, I have a checkbox column called "Ready for Production." I want to design it so that…
-
Ability to publish read only link of a single sheet in a collection without needing to log in/be a member
Hi, We have apps in place with Jotform to create ease in communicating changes in schedules. We have one sheet with a schedule that is within a collection of sheets that can not be shared. We would like to share the single sheet with people that do not have access to smartsheets (non-members). When we tried to make the…
-
Asset selection for sharing within the Workspace
Currently, in order to share specific sheets or reports within a workspace, each item has to be individually opened and shared with the user or groups. There should be a way of selecting the items/folders and sharing when you do not want to share the entire workspace. Doing this now will only share the whole workspace.
-
Automated Workflow - Assigning Multiple Contacts to a Cell
I have create a project intake form for my program. In my form, I ask the user to select the departments that a project will involve (e.g., Communications, Product Development, Field Team, etc.). I then created an automation where, depending upon the department selected, a person was assigned in a contact column to the…
-
User Status Change from Editor to Viewer
Has anyone had an issue where collaborators have lost their editor access to a worksheet? If so, how was it corrected? I have tried removing and resetting, clearing history cache, ensuring Publish:Read Only is OFF, etc. I could rteally use some help.
-
CC'ing yourself when sending email to all shared users of a sheet results in hundreds of emails cc'd to yourself
Like the title says. I wanted to send an email to all shared users of a sheet. I checked the box for 'cc myself' and it cc'd me on each individual email it sent to each user. I received hundreds of emails in seconds all with the same subject.
-
Master Project Plan
I have a massive project that spans across multiple regions. I want to segregate my plan into region sheets so when I update each individual plan the master plan will be updated. How can I do this?
-
Complete % calculation issue
I’m having an issue with the % Complete roll-up in Smartsheet. In the File Storage parent row (line 10), two out of the three child tasks are marked 100% complete, but the parent row is still showing inaccurate % instead of calculating the summary correctly. Could you help check why the parent row is not calculating…
-
K-12 Education
Hello everyone, my name is Alan Miller and I am an Executive Assistant working in K-12 education in Grand Junction, Colorado. I would just like to introduce myself and share some of the uses of Smartsheet that I use within my industry. I have been using Smartsheet for 4 years now and just returned from my second time at…