-
Cross Sheet References to an Empty Sheet
I'm building a master metrics / rollup sheet for a portfolio of projects. Each project has it's own workspace and a set of sheets (project plan, risk log, issue log, etc). The rollup sheet has one row per project and each column represents a metric, for example, High Severity Risks. The approach I've taken is, in the case…
-
Help with Dates not spanning over days that are not being used.
So, as you can see there in the calendar view I have this meeting that occurs every Monthly Monday, but the end date for this meeting stops on 1/25/24. The issue that I'm having is how can I have this meeting show up only on Mondays every month until that end date. Also, I have a formula that is set up, and I have…
-
Branching Logic (Trees) on sheet
Hello! I am relatively green when it comes to Smartsheet. I am looking to create a sheet that will track various channels of customer feedback, the solutions, who it is assigned to, WIP, RCA, and status. Currently, we keep these in separate databases and we want to combine them all in Smartsheet. Because the base issues…
-
Does anyone have a trick to remove sharing of multiple users on multiple sheets?
I have a terminated user who owed 2000+ sheets. I need to remove sharing on all the sheets before I earmark them for future deletion. Has anyone figured out a way to bulk remove sharing of multiple sheets and multiple users?
-
Do automated workflows operate on specific rows?
Hello, I want to set up an automated workflow that triggers when a column is changed to meet a specific criteria. When this trigger is met, will it run the workflow on every row in the table, or only the specific row which the trigger was met? My sheet has hundreds of rows and will likely have rows that change and meet…
-
Suspending a form for another to complete
Greetings all, I have a quick question. I have a form that my staff has to fill out on a daily basis. I would like to know if the form can be saved/suspended for someone else to finish before submitting it. TIA Matt
-
sharing sheet
Hello, I've created a form, where the back end of it is a sheet where all the information is saved. I want to restrict visualization based per person and division. So for example, IT can only see their IT information, HR their HR information..and so forth. without sharing the entire information to everyone. Thanks.
-
Unlock specific cells
Hi SS community, I am trying to unlock a specific cell in a sheet. The column needs to be locked because it is a "Start Date" column, but the one row needs to be manually inputted. Can I lock the entire column, but unlock the row or something? Please help me figure out a solution to this. Thanks!
-
Logic in Forms - not optimal
Dear Community, I have a problem with the Form we used a lot of logic so if the person choses proper answer another question is shown. If the question is not optimal there is message in red shown (using header). So if someone clicks all proper answers he is shown with the last question and based on it there are 3 messages…
-
Sharing Qualitative Survey Results in Viewable Format
Hi All, I am looking for a way to display qualitative survey results in an easy-to-read format. Here's some background. Someone created a survey with over 10 open-ended questions and asked over 10 people to respond. This resulted in receiving over 100 unique responses. Some of the responses are as short as 5 words, but…