PTO formula =IF([Yrs of Srv]@row >= 5, "20", "15")
Remaining PTO Days formula =PTO@row - SUM(CHILDREN())
When I manually input the PTO days without a formula, the remaining PTO days formula worked. Once I added the PTO formula, I received the error.
Hi @shornbuckle1072
I hope you're well and safe!
Try something like this.
=IF([Yrs of Srv]@row >= 5, 20, 15)
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
That did it! Thank you so much. I figured is was something simple, I just couldn't figure it out. :)
@shornbuckle1072
Excellent!
You're more than welcome!
Easy to miss!
=IF([Yrs of Srv]@row >= 5, "20", "15") The "" surrounding the numbers make Smartsheet interpret it as text.
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.
