-
Project Status to Update a Sheet Summary Status - Formula?
Is there a way to have a formula in a row or in the sheet summary that does the following: When a row is added in one sheet and the project status is Completed, then within the project itself in Sheet Summary change the status to Completed as well? I am not sure if it is possible as one status in one sheet would have to…
-
Merged: Move/Add row automation: The ability to choose if the row populates at the top or bottom of…
This discussion has been merged.
-
Log in needed in Microsoft Teams to access sheet not working
I just got Smartsheet integration with Microsoft Teams set up, and yesterday it was working beautifully, being able to see and edit the sheet within Teams. Today when I opened Teams, it's asking me to log in to smartsheet, taking me to my brower. When I do, nothing happens in Teams. When I refresh the tab in teams, it's…
-
Can you cell-link within the same sheet?
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
!! Help share content!!
Guys! The smartest people I know! Does anyone have recommendations or best practices to do or do not do related to sharing materials with customers. We currently share a Workapp with implementation customers. And I do not have a good resolutions for sharing files, videos, user guides attachments either via upload or link…
-
Would auto number duplicate a value if a row is moved to a different sheet?
Hello, I currently have a sheet that assigns an auto-number value for each row. Upon certain actions taking place, this row then gets moved to a different sheet. Because that row got moved, would that free up that specific auto-number value to be used again? I am hoping not as we are looking to use this as a unique…
-
Creating Form where questions will change as per the input from user
I wanted to create a form but i want the form questions to get updated as per the input provided by the user. For example how we have the marketing survey, depending upon the input provided the following question gets changed. Is something like can be done in Smartsheet form as well ? Please help me out or guide me to such…
-
Is there a way to set row heights in a sheet back to standard?
I am trying to create a report to add to a dashboard. The sheet I am pulling from previously had several rows expanded due to large comments and the wrap text feature. To pull into my report, and for view of leadership, I would like the rows to be standard for a cleaner feature. Any ideas?
-
Issue with Cell Linking from Metadata to a new sheet in the same workspace
I have an existing workspace for a project. I used the PMO template to create all my workspaces. I added a new sheet w/in the project's workspace and want to link the Project Name from the Metadata to this new Onboarding worksheet. The link shows up but the name does not appear. I've saved, exited, refreshed, etc. but…
-
I have some questions about using smartsheet for managing sign ups for courses
The aim is micromanage / manually edit lists as little as possible. I would like to use automation for situations below: Is there a way to automatically stop/block the option for duplicate enrollments from the same person ( based on email address)? Set a default maximum limit for enrollments? ( stop registration option…
