Update the cell value by 1 on the 1st of every month
Hi,
I want to update the cell value by 1 on the 1st of every month.
Suppose the current value of my Earned Leave Column is 10, on the 1st of every month I want to increment it by 1.
Tags:
Answers
-
Do you have a column that houses the starting date and potentially a column that houses the starting amount (if not all start at zero).
-
I can create a start date column, not an issue.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!