Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Creating a lead time formula
NShimy
✭✭
I am trying to create a leadtime formula between duration, start date, end date and predecessors. Help please. This is a new system for me. 🥴
Answers
-
Duration calculates the End Date based on the Start Date. Which date column is used to determine the Start Date?
-
Hi. If I’m understanding what you’re asking it would be column 9…. I am trying to auto populate a formula for lead times with all of our different projects. Thanks.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am new here, but cannot figure out how to make a nested if statement or an automation to change the status based on a date in the past. What I would like to happen is when any of these dates are in …
- Good morning, I would like to write a formula that counts the instances where the text "Monday" appears in a given range. I've tried: =COUNTIF(CONTAINS("Monday", {Waitlist Range 2})) and some others t…
- I am creating a formula to look at an instructor's name on one sheet and see if it exists on another sheet (verifying that a qualification has been completed). My formula sort of works, if there's a m…