Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to Create a NetSuite Formula to Display Blank for Project End Dates Past Today's Date?
Hello,
I create a saved search of projects (in progress and closed) and attempted to add a formula field to calculated "Days remaining until project end date" for active projects. However, the formula entered a negative number for expired date. I would like the formula to display nothing (blank) for project end dates that have passed. Below is my current formula (numeric) I used.
ROUND({custentity_project_end_date}-{today})
Please advise, I'm new to using formulas in my saved searches.
Thank you!