Calculating a date using a 'date' column and a 'number of days' column

Victoria Ganuelas

Victoria Ganuelas ✭✭✭✭

04/18/23 edited 04/18/23 in Formulas and Functions

I need a formula that takes a 'date' column and minus' the number in a 'number of days' column to show that calculated date in another date column.

0 ·

Answers

=Chris Palmer ✭✭✭✭✭

04/18/23

Hello @Victoria Ganuelas
This should work:
=WORKDAY([Original Date]@row, -[Number of Days]@row)
Make sure the column type with the formula is set to Date.

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

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Basic Cross Sheet Reference Not Working
I am trying to create a very simple formula to count the number of rows in a sheet based on status type. I'm getting an "unparseable" error and I can't figure out why. I've tried both the below criteria and "Intake" and am receiving the same result. Any ideas on what might be broken here??
Required/Mandatory Column
Is there a way to make cells in a particular column required/mandatory. Like no other cells can be edited until the cell in that column is populated?
Automated Check box when a sum of cells is greater than another cell
I am trying to create a formula that checks the box if two cells are equal to one other cell. Getting so frustrated, please help! 🙏 This is the formula I have that is not working for me: =IF(AND(TotalA@row, TotalR@row = TotalM@row, 1, 0)) What am I doing wrong?