-
Is there a way (or workaround) to make the "Send me a copy of my responses" a mandatory field in the
Is there a way (or workaround) to make the "Send me a copy of my responses" a mandatory field in the forms? Thank you
-
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?
