How to use a populate a column in a smartsheet by using a formula.

Paul Hansen

If column b is required to be exactly 6 months after column a.

Column a was specified in a form.

Is there a way to insert the following formula into the column or worksheet:

=IFERROR(DATE(YEAR([Last Calibrated]@row), (MONTH([Last Calibrated]@row) + [Calibration Cycle]@row), DAY([Last Calibrated]@row)), DATE(YEAR([Last Calibrated]@row) + 1, (MONTH([Last Calibrated]@row) - [Calibration Cycle]@row), DAY([Last Calibrated]@row)))

Where [Calibration Cycle]@row = 6

I will need to keep the calibration cycle in the formula as it will need to be used for 3,12,24 months etc etc

Andrée Starå

Hi @Paul Hansen

I hope you're well and safe!

Sometimes when the formula is more complex, I add a simple formula first and make it a column formula, and then I edit and replace it with the actual one.

Try something like this.

=Cycle@row

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!