Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
General Discussions
Discuss any topics that are not product-specific here.
SOLVED
I am attempting to get these blank cells to be automatically replaced in excel as "N60". I am assuming this will be done through a formula tool after selecting the pay terms column. Could anyone assist? Thank you in advance
Solved! Go to Solution.
Hi Maddoxs!
You're correct in assuming you can use the Formula tool. As seen in the screenshot below, I used a Formula tool with the Pay Terms column selected. I used a simple if statement to get the output necessary.
