-
Time Elapsed to Today in Months/Years
Hi! I'm trying to figure out how to use the NETDAYS formula to show how long someone has been a member of a certain team. I can't get it to measure to today using the formula that the website suggests. I want it to be running so that whenever I log on I can see the time elapsed to the day I'm looking at the sheet. Can…
-
Column Finder
Provide a better way to find a column in sheet. For sheets with many columns, it is sometimes difficult to locate the column that you are looking for. It would be better if there were a dropdown that listed all columns in alphabetical order so that selecting it takes the focus to that column.
-
Merged: Courier Log
This discussion has been merged.
-
Prepopulating Forms
I'd like to be able to enter a unique value in a form and have it prepopulate a few other areas of the form. For example, I'd like to enter an employee ID number in the FORM, and once entered the First and Last Name sections of the FORM would automatically populate with the correct information.
-
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.