Conditional Cell linking between multiple sheets

Meghan Lundy

I have created two sheets, one for budget tracking and one for tracking PO's and Invoices. I would like to link the two sheets conditionally when and invoice is marked paid.

 

When an invoice is paid, the current date is marked as the paid date. I would like the Invoice dollar amount to be added to the budget sheet in the appropriate month under the line item / cell that the invoice vendor belongs too.

Shaine Greenwood

Hi Meghan—Smartsheet doesn't have conditional move row functionality, but our Product team is currently in development on this as we realize the potential of such a feature. I'll add your vote to our enhancement request list as well so the team has visibility on your use case.

 

For the time being, there is a paid service called Azuqua that will allow you to create conditional move rows: https://azuqua.com/