-
Master Contact List for use across sheets in a workspace
I have 16 grids that all use a Contact List with 23 of the same client contacts. (1) its a HUGE waste of time to have to populate 23 contacts into a list 16 times and (2) every time a new person joins or leaves the team, I have to go into each of the 16 grids and make the same change. Is there a way to create a contact…
-
Using Smartsheet As My Daily Projects & Task Hub
Good afternoon, I am looking for recommendations on the best way to use Smarsheet as my daily place to stay on track with projects and tasks. I am tired of working in multiple different software's like email, Teams, Smartsheet and so on. I want a one stop shop place to do everything. I find myself getting distracted and…
-
Timestamping
Hello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Best way to track and plan task and projects in a dynamically changing manufacturing environment?
Help!!! I have been using Smartsheet as a novice user for a year now. I know that it has great potential to track and plan tasks and projects across multiple users and departments. I work in a manufacturing environment where every day there are issues that come up with production machines and need to be planned and…
-
Create SUMIFS formula with a contact criteria in a multiple contacts range
Hi, I am looking for the right way to build my formula that makes a sum of a number column with a contact criteria in a multiple contacts range. Example: =SUMIFS({numberRange with hours}; {Criteria Range with multiple contacts}; Contact Name; {Range with Statuscode}; "In Progress") Check also the screenshot below. If I…
-
Disable auto update of start dates for dependent tasks
Looks like there was a thread on this https://community.smartsheet.com/discussion/7262/forced-dates-when-dependency-is-enabled to disable auto-update of start dates when using the predecessor feature.. is this implemented?
-
Locking cells in sheet
Hello, I am trying to determine if there is a way to lock the formulas I have placed in my sheet so that the users cannot override them to hard key in numbers. The formulas have been entered into all of the necessary cells but as it stands, users can simply clear them out to enter the amounts in their own way. We have…
-
Control Center & Cross-Sheet References
Hello all, This is my first attempt at SCC provisioning of sheets and I ran into my first problem. There are three sheets in the blueprint -> Sheets A1, A2, & B. B pulls in data from sheet A1 and A2 via cross sheet references (index/match so I can reference by a key value in case rows move around in A1 and/or A2). When I…
-
Multiple Projects = Multiple Sheets?
HELP! Our company is moving to Smartsheet and I have very limited knowledge on set up and functionality. I've gone through the videos and read almost every tutorial and I know I have much to learn but the main question I have is the initial set up. I feel the set up is crucial and if I can get that correct, I can get…
-
Developing Library check-out list
Hi! I am looking for suggestions/help on a formula for a library check out sheet. In columns I haveL check out date / Number of Copies / Copies Available. I am struggling to figure out an automated process to get the copies available to update once when the number of copies is changed. When the form is submitted it says…
