-
Sheet Summary changes overwritten by other users - can this be prevented?
I have a sheet that has sheet summary values I occasionally need to update the formulas for as factors change however I've found that when other users are updating the sheet (it's a testing sheet) the changes I make to sheet summary formulas are overwritten as those users update their test statuses. Aside from making the…
-
How to create a unique number via formula or how to autonumber via formula due to existing autonumber type column?
All, The way my Smartsheet workspace works: Every time the Status column of a particular request in Master sheet is changed, the entire row is automated to be copied to Status Tracking sheet. The change is timestamped as Change Timestamp and the Subsequent Timestamp is recorded in Status Tracking sheet with every…
-
Group Columns in Grid
Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views. I feel like the best (and only) solution right now…
-
How can stakeholders search within a Dynamic View?
Hello! This is my first post in the Smartsheet Community - thanks in advance for any help. Problem: I’ve created two Dynamic Views that consolidate data from multiple systems into Smartsheet. Each row represents a unique SKU, and stakeholders need to search by SKU to view multiple status columns coming from different…
-
Created Time
So I am trying to extract the timestamp from the created date column and its making me feel crazy. The TIME() function help file describes a formula that should work exactly how I want - however NOTHING as described works at all. (https://help.smartsheet.com/function/time) =TIME([Date Created]@row) returns "INVALID DATA…
-
Is Linking sheets feasible when there is a maximum number of linkages
HI I have created a smartsheet for a plumbing business, the boss wants a master one where he has financial info which I have as the master one and then a working one for the forman that updates the master but does not have the quoted or accepted price. Is this a dumb thing to do since the is a cap on linkages. Is there a…
-
Can automated email come from a specific email address?
We created a tracker for the Records Management team and need all emails coming from the tracker to come from the email address associated with the team. Is there a way to have all emails come from this specific email? I see options for the owner or from general smartsheet but not an option to have it come from a different…
-
Help with using the PMO template to Manage an IT projects
Hello, I have a digital transformation plan that is set to span 3 years. I want to use the PMO template to setup an environment to manage plan. An IT PMO workspace of sort. I have a number of questions on best practices, managing projects sheets among other questions on how to setup the 7 domain projects that has other…
-
Move to and Copy To Window
We have thousands of sheets (8 sheets per projects and 5000+ projects) in our environment. One feature that does not work is selecting a row in a sheet and choosing “Move to Another Sheet…” or “Copy to Another Sheet…”. The action spins indefinitely and never loads the list of available sheets even when typing in the sheet…
-
Scheduling Calendars Switch to Smartsheet
Hello! We have a scheduling team that is working out of 5 Google Sheets they created to look like calendars - each tab is a new month and each role they schedule has a different Sheet. There are different scheduling rules to take into account with each role type which makes it nice to see them separately. Their current…