-
Representing Milestones landing in Financial quarters
Hi, I'm new to Smartsheet and hoping that what i'm trying to achieve may be possible but have drawn a blank on the help and community topics so far. I need to be able to represent that a project milestone is landing in a specific financial quarter and then have this represented on the Gannt chart. Ideally i would have…
-
Formula to add a number in a cell based on other figures
Hi hoping for any help I can get on this. Using the image as a reference. Im trying to make [Length score] show a number between 1-4. the scenario being if the length is 30 days or less it equals 1 and between 30-90 it would show a 2, between 90-150 show a 3 and between 150-365 show a 4. Would love any help on this people…
-
Keeping Formulas When Downloading to Excel
Hello, I found online that it says when you download a sheet into an Excel sheet that it does not keep the formulas as they are different. Now just in case, I thought I'd ask: Is there a work around for this at all? Is there absolutely no way to keep your formulas when you transfer them to an Excel?
-
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…