-
SUMIFS using Fiscal Year Date Range
I'm trying to sum monetary amounts for a certain customer while referencing the data from a separate sheet. However, I only want to sum those amounts that fall within the FY20 (fiscal year) dates of 4/1/19 to 3/31/19. Here's the start of my formula that sums all dates, but what conditional formula do I need to add that…
-
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.…
