I need help with the Advanced Formula in the Tables

  • OPC Jotform
    Asked on January 24, 2025 at 5:52 AM

    Hello, how can I convert this into a formula:

    IF Column A has a date, then it should return "Scheduled" if not then it should be "For Scheduling"

    I am having troubles navigating the advanced formula setting on tables

  • Lorevie JotForm Support
    Replied on January 24, 2025 at 1:07 PM

    Hi OPC Jotform,

    Thanks for reaching out to Jotform Support.  Can you send us the form URL? Let me show you where to find this:

    1. In Form Builder, click on Publish on the orange navigation bar at the top of the page.
    2. Select Quick Share from the left side window.
    3. From Share With Link, click on the Copy Link button and paste it on this thread.Approvals: Were getting an Error on the approval status Image 1 Screenshot 20 Screenshot 10 Screenshot 10 Screenshot 30

    Will you also grant us access to your account so we can check it? Don't worry, you can disable that again after we're done checking things out. Let me show you how to do it:

    1. In the upper-right corner of your My Forms page, click on your Avatar/Profile Image icon.

    2. In the small window that opens, click on Settings.

    I need help with the Advanced Formula in the Tables Image 1 Screenshot 41

    3. In the panel on the left, click on the Security tab.

    4. Then, on the bottom-right side of the page, toggle Jotform Support Access to the On position.

    I need help with the Advanced Formula in the Tables Image 2 Screenshot 52After we hear back from you, we’ll have a better idea of what’s going on and how to help.