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.

If or if error function

Debbie Sin
edited 12/09/19 in Archived 2017 Posts

Hi Community

I have three columns in the sheet, 1st one showing the entitle commission, 2nd one showing the commission paid date, the third one showing the commission due to paid, There are always an amount showing in Entitle Commission, If we have paid the commission, I will input the date on the commission paid date.  The   problem is here I would like to use the commission due to paid column to remind me to pay the invoice.  How can I use IF or IFERROR fomula to show that if the commission paid date column is blank, then the amount in Commission due to paid will be equal to Entitle Commission.  How can I make this happen





This discussion has been closed.