Sign in to join the conversation:
Hi
try to get a formula to do this.
If “DATE PAID” is blank, copy balance from “TOTAL CHARGES”
Hello Vivo,
You might try a formula like this:
=IF(ISBLANK([DATE PAID]1), [TOTAL CHARGES]1)
More on using formulas in Smartsheet can be found in our Help Center: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet
Thanks
that work