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.

Desperate for help with a formula

I need help with a formula.  I want to look at a revised date and the original due date, and have the value that is greater in another column for formatting purposes.  Here is what I am using. 

=IF(([Revised Due Date]734 - [Due Date]734)>0, [Revised Due Date]734, [Due Date]734).  Can someone help me ?   Thanks, Sharon


  • Hey Sharon,


    You could do something like this:

    =IF([Revised Due Date]1 > [Due Date]1, [Revised Due Date]1, [Due Date]1)


    So, if the revised date is greater than the due date, show the revised date. Otherwise show that due date.



    Here's another way: =MAX([Completion Due Date]1:[Due Date]1)


    This is just grabbing the max date in that range.

    Screen Shot 2016-11-14 at 4.12.32 PM.png

This discussion has been closed.