Jump to content

Need a calculation to show order status


This topic is 6564 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create a calculated field to display the status using the following:

Case(not IsEmpty(payment date), "Paid", not IsEmpty(invoice date), "Invoiced", not isempty(order date), "Ordered", "")

Make sure you set result to Text. Hope this helps.

Link to post
Share on other sites

This topic is 6564 days old. Please don't post here. Open a new topic instead.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.