-
Issue with Fiscal Year
Hi! Our Fiscal Year begins in February. This means we are in fiscal year 2026, with the first quarter ending at the end of April. However, in my Smartsheet timeline, the year is off by a year. The timeline shows FY 2027 rather than FY 2026. Is there a way that I can change this?
-
Idea funnel
Hi all, I'm at a manufacturing company. I am looking into a Smartsheet solution for idea generation and management. These could be cost improvements or reach into new product development. We would likely have project goals (improve margin, expand sales, ect), ideas (that need to link to SKU's and goals) and gather input on…
-
Resource Management - Project Efficiency
I think the best option for our Payor Relations team would be resource management and creating projects however I dont know exactly where to even start. I've downloaded templates and watched many videos and it leads me down a rabbit hole. We offer services to around 250 practices and renegotiate their rates every few…
-
Merged: Representing Multiple Phases on a Single Gantt Chart Row
This discussion has been merged.
-
Does Smartsheet Support "Schedule Performance Index" (SPI)?
I've seen some past posts where users tried to create their own columns for this, but they seemed to have errors in the way the calculations were done. What is the latest solution from smartsheet (or recommendation from end-users) to have a calculation that works correctly for SPI? It should be SPI = Earned Value/Planned…
-
Formula to pull the Fiscal Year from a Launch date
Hello! I'm looking to pull the Fiscal Year in a cell based on the launch date in a different cell. Our FY starts on 04/01 of the current and ends on 03/31 of the following year. I need the formula to determine if the FY is the current year, the prior year, or the next year based on the launch date. For example, 04/25/2024…
-
New copy of an old project
Hi! We have a long list of about 100 projects in a sheet - about 80 of them will be "restarting" or "renewing" this year. Instead of making the requesters fill out the intake form again, I'm hoping to save some time by copying rows from "this year's" request to "next year's" request, and just make some minor updates to the…
-
Projected Labor Needs & Labor Schedule
I have multiple tasks with various durations. At some point, most task's duration overlaps with another. I need to project out on any given day what my total labor needs would be for that day. I have two sheets: Sheet #1 - Labor Schedule Sheet #2 - Projected Labor Needs In the snip-it below (Top Part Clouded) I have…
-
Manpower Projection Formula
I have multiple schedules for different projects with the same base information: Task Name (Primary) Start Work Date End Work Date Duration (Dependencies are enabled) Manpower Needed Many tasks have durations that overlap with other tasks. I want a separate manpower projection sheet that tells me each day what the total…
-
Date formula query
What formula to use, to calculate records from today till 6 months down the line? And this rule should be valid at all times. In other words, how to calculate sum of values eg: count of total number of projects starting from today (26/April/24) till 12 months down the line i.e. 26/October/24? For sum of values starting…