Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Autofill Formula to Pre-Existing Row
On a pre-existing row of data, I want to have a formula autofill when I input new data., i.e. when an escrow closes for a client.
In Excel I would simply pre-populate the column by stuffing the formula below into row 1 and then dragging down to row 2,000 then locking the column. Can I do something similar in Smartsheet?
IF(ISDATE(Escrow Close Date), (Sale Price) * (Commission Rate), ""