-
Formula - IF and VALUE function
I'd like to figure out how to execute the following function. If a cell contains certain text, fill in a numerical value in another cell. For example: If cell A1 says "Request Type A" then fill in "3" in cell A2. If cell A1 says "Request Type B" then fill in "5" in cell A2.
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Stacked Chart
Hi All! I am trying to move a document from excel into SmartSheet and I was wondering if anyone knew if I could recreate this data into a dashboard chart? It is not currently set up as a chart in excel, it is a tedious exercise of lengthening and creating new shapes to designate the progress. I have tried a couple…
-
Jira Connector with Story Points
We have been successful, through trial and error, getting Jira connected to Smartsheets in a bi-directional fashion. One key piece of functionality that would be helpful is utilizing the story points from our Jira system. I noticed in the workflow builder we don't see that as an option to migrate our Jira Story points into…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
Color Palette
OK, So I figured others might find this useful. I couldn't find it, so I made it by exporting the palette from SS into Excel and divining the numbers. It's the RGB color scheme for Smartsheet for Excel 2013.
-
Row numbers to a dashboard
We monitor the number of requests that come into 3 different Smartsheet forms week over week... i created a dashboard to show the requests within the past 7 days, but i need the rows to tally... even if the row number shows up on the dashboard itself, that works - i can simply see that 45 rows were created in the last…
-
Auto Assign a Predecessor in Gantt
Hi, I have a series of standard processes that have the same dependency and predecessor data each time. I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.). If pre-assembly is selected, for example, I always want it to…
-
How to get the sum only for a Specific Dropdown Value Selected
Hi, I want to get the sum for only the dropdown value selected: Here is the Situation: First Column: I have 3 Resource Type: 1. Offshore 2. Onshore 3. Remote Column 2: I have resource Name Column 03 to 35 is a Hour Cloumn ( Where it shows how mnay hours each of my resource is available to work) Now I need to calculate: 1.…
-
Formula returning a blank cell
I have been trying to figure this out for hours with no luck. We've created a formula to automatically update our status column in our project plan sheets. We have specific parent rows that are designated as milestones. The milestone row status cells should update based on the status of the child rows. A milestone row is…
