Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Cell Value Capture for Monthly Reporting

Hello,

I am trying to build an executive summary dashboard and would like to capture cell values at the beginning of every month to compile on a monthly basis. I have thought about using a row copy automation however i need to build a "capture sheet" for the dashboard to reference for several data points (total invoice balance, break down of those balances by party, balance of invoices over 60 days, etc.). Is there a way to capture and copy a cell value that is derived from a formula to another sheet on a monthly cadence being directed to different cells?

For Example:

When date is the 1st day of the month, log the cell value is green to the specified cell for that month.

image.png image.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions