Formula to add a # of days to a date to calculate ETA

bgoodman · 2022-01-26 22:15:42

I have a form that calculates a TAT based on the amount of material requested (1-2 items is 4 days, 2-5 is 6 days, etc etc). I also have a column that is a date only version of the time stamp, so the requester does not have to enter "Date of Request" inthe form, it defaults to the date of the request this way. What I want…

Answers

Paul Newcome ✭✭✭✭✭✭

08/23/24

@Kayla H. To add 6 months to a date, you would use this:
=IFERROR(DATE(YEAR(DOE@row), MONTH(DOE@row) + 6, DAY(DOE@row)), DATE(YEAR(DOE@row) + 1, MONTH(DOE@row) - 6, DAY(DOE@row)))

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
How to Automatically Checkmark a Column for entries that are created within a time-based timeframe
I'm trying to write a formula that will automatically place a checkmark in a checkbox column titled "Today Entry" whenever entries meet the "Created" column criteria of being submitted after 1100 AM the day prior and 0800 AM today on a rolling basis: I've been trying to use the below column, but honestly I have no idea. I…
Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…

Formula to add a # of days to a date to calculate ETA

Answers

Help Article Resources

Categories