How can i have a cell that shows an amount from another cell if its 30days past a date in another ce

row 1 date billed

row 2 dollar amount

row 3 dollar amount past 30 days

Row 4 dollar past 60 days

Row 5 Dollar past 90 days

=if( row 1 is less then 30 days) show row 2

=if( row 1 is less then 60 days but greater then 30 days) show row 2

=if( row 1 is less then 90 days but greater then 60 days) show row 2

=if( row 1 is greater then 90) show row 2

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!