-
Logging and tracking cross-sheet functionalities
Hello! My organization uses cross-sheet functionalities (formulas, workflows and API) pretty intensively. So much that when we are working through ideas to embed new processes, it can be a bit cumbersome to understand what is already at play. Essentially, we do not have any type of log or systems map to reference where or…
-
Approval sent to only one of 8 choices
Hi - I work in higher ed and I am trying to create an application that when a field is changed to one of 8 choices, that only the choice selected gets contacted for approval. For example, the school chair A is what is selected in the field of drop-down menu choices. How do I set up the automation, that only Chair a is…
-
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.
