Determine # days from 1 date range to today

edited 12/09/19 in Formulas and Functions

Looking to assign a % complete to a project based on days from open to estimated close. Have a column showing total network days from these dates and now want to either nest a function to subtract the overall days from the current days (open to estimated close minus open to today). I am new to Smartsheet so am having a problem getting the "today" part set up correctly, Any input is appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!