Sign in to join the conversation:
I've done some research, so I'm pretty sure I already know the answer. I have a project with a hard completion date. I would like to have any subtask scheduled backward from the completion date. Can that be done in Smartsheet?
Hi,
There is a Template called: Project with Hard Deadline and Gantt that probably is what you´re looking for.
Hope that helps!
Did it work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Andree,
Please enter the link for this Template or information you found. Your comments are useless to everyone searching. This is not the best website for searching and finding correct answers at the top of the list. On these community boards we need to be accurate in the links to point people in the right direction. Thanks.
At the time of my post, I don't think it was possible to link to the templates but now it is so here you go:
https://app.smartsheet.com/b/home?sc=mjjH3-k10qQ%2Cm9FH33U15fo%2C1
I hope that helps!
Workflow Consultant / CEO @ WORK BOLD
This Template is located in the SOLUTION CENTER
Go To Solution Center
Enter Search : Project with Hard Deadline
You will see the Single Project Template Called
"Project with Hard Deadline and Gantt"
Click on it and it will appear in your SmartSheet Collection
Not much to look at but at least it can start a person in the right direction for entering a Deadline Date and the remainder of items get scheduled using predecessors with SF with task below.
My link above is the direct link to open a copy in your account.
Here's a link to the Solution Center page with that specific template.
https://www.smartsheet.com/marketplace/templates/project-hard-deadline-and-gantt
I have a sheet that I am using to collect COI from faculty, but our faculty often are involved in multiple activities that often leads to them inputting several COI entries. I've managed to create a duplicate checker to see which faculty members have entered their COI twice, but that doesn't necessarily solve my issue of…
I have a number of automation that send notification emails to clients. These are automations that have worked successfully for years, and suddenly they stop. I am a recipient on many of these notification emails, and I realize that I have stopped receiving these notifications as well as of Jan. 26, 2026. It's a…
I’m hoping someone can help me understand a strange issue I’ve run into. I have a workflow that sends a single Update Request when the date in a row matches today’s date. This automation has been working correctly for a long time—each contact would receive one email on the day it triggers. However, recently the workflow…