What formula would I use to calculate 120 prior to a date listed in my sheet?

April Feldt

April Feldt ✭✭

05/11/20 in Formulas and Functions

This is the formula I tried and it is #UNPARSABLE.

0 ·

Best Answer

Mary_A ✭✭✭✭✭✭

05/11/20 Answer ✓

You need to use WORKDAY function here.

https://help.smartsheet.com/function/workday

WORKDAY([Renewal Date]3, -120)

5 · Share on Facebook Share on Twitter

Answers

Mary_A ✭✭✭✭✭✭

05/11/20 Answer ✓

You need to use WORKDAY function here.

https://help.smartsheet.com/function/workday

WORKDAY([Renewal Date]3, -120)

5 · 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

Formula to check a box when specific criteria are met
Hi! I am looking for a formula to check a box when specific criteria are met. I have multiple columns that have dropdown options. I would like the box to check when each of those columns have either "Approved" or "Declined" selected. But if "Submitted" is the option shown, then it should not check the box. So all…
Formula to populate field from another sheet using multiple criteria
Hi there, In one sheet ("pay scale") I have our employee pay scale and in another ("Employee Salary") I have our employees listed with their experience and education levels. Is there a Smartsheet formula that I can use to pull in their salary based on their experience and education levels? For example, if they have a BA +…
Forumla Help: IF Statement with Vlookup Across Sheets
I have created two resourcing documents (pictures below for a visual) Resourcing Sheet - This is the sheet where we resource each project by person Resourcing Rollup- The sheet is rollup to show how many hours the are allocated each week by person and gives a rollup of hours What I am trying to do: Look up (example name)…