Bill Payment Function Needed

Charles Wells

I am looking to to create a spreadsheet that has the following functionality: 

- Bill Date Column updates based on the frequency (monthly, quarterly, yearly) every time the check mark is checked. 

 

Example:

 

Verizon / $100 / 3/1/2017 / Monthly / Paid (Check or Uncheck)

 

J. Craig Williams

Charles,

 

Here is how I do it:

 

http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/

 

If you can be sure the row won't changed after checking the box, there is a formula posted elsewhere in the Community.

 

Craig