Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using multiple functions in a formula
I am using a formula to determine "Planned % Complete" based on start date/end date and todays date. The formula I am using is;
=(MIN(TODAY(), Finish1) - Start1 + 1) / (Finish1 - Start1 + 1)
I want to nest the following formula so that if the start date is AFTER todays date, the "Planned % Complete" will be zero;
=IF(Start1 <= TODAY(), 0, 0)
Now, I would also like to add an element that removes weekends between the start and end date using the WORKDAY function.
Any suggestions how I can use all three functions in the same cell? Or an easier way to calculate the "Planned % Complete" obtaining the same results as mentioned above?