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

Converting a date/time text format to a simple date format
Hey everyone - I am trying to convert a text field that reads 2024-09-25 15:35:27 to a simple date format, either 2024-09-25 or 9/25/24. I've tried using a helper column to just pull out the text date string - =LEFT([Registration date]@row, FIND(" ", [Registration date]@row) - 1) in the hopes that would be convertible to a…
what is wrong with my formula join collect?
=JOIN(COLLECT({Rollup Tracking: Preceptor Activity Month}, {Rollup Tracking: Preceptor Activity Preceptor Name}, [Preceptor Name]@row, {Rollup Tracking: Preceptor Activity QTR}, Qtr@row, {Rollup Tracking: Preceptor Activity Year}, Year@row), CHAR(10)) I cannot see why this doesn't work…i have similar formulas on other…
How can I display data horizontally from data in a row format
I have metric data on a project that I am capturing weekly that I would like to view horizontally week over week for the current month. I'd like to do this dynamically so I can pull the data into a dashboard. This is what I have in my metrics sheet: This is how I would like the data displayed: Any advice you can provide to…