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.

Formula Help

Vivo Moshe

Vivo Moshe ✭

02/01/17 edited 12/09/19 in Archived 2017 Posts

Hi

try to get a formula to do this.

If “DATE PAID” is blank, copy balance from “TOTAL CHARGES”

0 ·

Comments

Shaine Greenwood Employee

02/08/17

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

0 · Share on Facebook Share on Twitter
Vivo Moshe ✭

02/08/17

Thanks
that work

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Try to capture Minimum and Maximum dates
I set up 2 columns ("Start Date" and "End Date") on a sheet. I would like to populate the heaer of the column with the minimum Start Date and the maximum End Date. But I just get the error "This Column is restricted to dates."
Is there a best practice formula to use for this scenario?
I'm attempting to grab the value circled below on a daily basis and feed into in a master spreadsheet. I'm using a MAX formula in the latest record to help me capture the relevant record. It would feed into this spot in my other spreadsheet My thought is to do a formula to say if latest record is checked, grab value in…
Changing Status Symbol from "Hold" to "Yes" depending on dropdown menu entry
Hi all! I am looking to utilize the "Hold" and "Yes" symbols (Yellow triangle with ! and Green circle with check mark) as a "health indicator" depending on a specific value recorded in a dropdown menu column. I have a dropdown menu column whereby the you can select either "E-MAIL" or "REPORT" as the value of the "Last…