Hi, hoping for assistance!
I currently have a day counter formula:
=NETDAYS([Posted Date]@row, TODAY())
within a "Req Age" column. How do I stop counting days when a date is entered into my "hired date" column?
thank you!
=if([hireddate]@row<>"",Netdays([Posted Date]@row,[hired date]@row),Netdays([posted date]@row,Today()))
Thank you @Hollie Green
Unfortunately, I'm getting the #unparseable error when entering that formula
@Hollie Green NVM, I figured it out. I just needed to add a space between hired and date. Thanks for your help!
Excellent! Glad it worked for you. My space bar is difficult sometimes and doesn't actually accept the input.
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
