-
Allowing people to access reports without having access to the main sheet
Is there any way that I can share reports with various people and give them the ability to edit information through their report without sharing the main sheet with them? In other words, giving them write access through the report, but not allowing them to see, open, write on, or access the main sheet in any way? They…
-
Creating a technology device loaning process
Good day everyone. I am new to the community but not new to Smartsheet. Have been using at my company for a number of years now. My team has acquired a quite a few pieces of equipment and it seems that we are constantly loaning them out to other teams for certain periods of time. I have been working on a loaning process…
-
8/21 Education Industry Solution Spotlight - Register!
Due to high demand, we are thrilled to invite you to our second Smartsheet Spotlight designed exclusively for our customers in Higher Education, K-12 School Districts, and Education Organizations. In this spotlight, you will learn about the art of the possible for some of our most common use cases we see across our…
-
Smartsheet for Curriculum Planning & Execution
Hello Friends, Have any of you used Smartsheet for curriculum planning in public education or employee training? I am in the process of building a 4 year high school business and technology program and am considering using Smartsheet, or something similar, to develop a plan. Thanks and feel free to share if you have some…
-
How do you create a sheet that calculates 60 weekdays minus holidays?
Hello, I am trying to create a sheet that calculates 60 school days from a specific date. It needs to omit weekends, holidays and breaks. I used the following formula and it is still not calculating correctly. =WORKDAY([Document Date Signed]@ros, 60, [PPS Holidays]@row) I entered all of the holidays in the holiday column…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Manual Copy and Paste of rows fails to paste formulas and hierarchy
About 3 weeks ago I began being unable to copy and paste multiple rows between sheets in smartsheet. I have about 12 rows with several columns that match columns in a separate sheet. I am trying to copy rows from one sheet manually using CMD+C and CMD+V (I am on a mac) and paste them into the new sheet. I am able to select…
-
Coloring
Is there any way to use Color Hex Codes to further customize the columns, rows, and/or text of our workspaces? If not, please add this in future updates.
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Greetings from New Jersey!
Hi Smartsheeters, I am fairly new to Smartsheet. I've been using it since November 2023. Just earned my Core App certification. I'm hoping to increase use of Smartsheet at my company and find ways to automate processes and integrate data from other systems. On the weekends I'm busy doing pottery and riding my ebike.