Can SmartSheet copy data based on two dates?

I'm looking for help with a formula that could copy data from one cell to another in the same sheet based on a start and end date. If the row is "active" today's date is between the start and end dates, it will copy the data over.

When there are future dates as is shown with the row that says New Allocation, when today's date reaches that start date, it will copy the allocation data into the first column. Right now I have a workflow that clears the first column when an allocation ends. Would I still need that workflow if the formula is checking start and end dates for copying the data? Would the formula also clear out the data when the end date is reached?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!