I would like Smartsheet to Return Number of a Pay Period based on Current Date

Hi everyone. Thank you in advance for trying to help me. Here is what I have.

Based on Today's Data aka Current Date.. I would like to my Pay Roll Information sheet and return the Number of PP. Based on this current date, It should return 6. This sheet contains my Pay Period Information

I am trying to get it to return to my Employee Information sheet so I can calculate the number of PTO Hours.

I have tried several formulas. These are just a couple...

INDEX(COLLECT({Payroll Information Num PP}@row, {Payroll Information PP End}@row, >=[Current Date]@row)

=IF(AND({Pay Period Begins}@row <=TODAY(), ({Pay Period End}@row >=TODAY()), ({2024 PP Number}@row)))

💐 Please

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @Catly,

as i understand from your formula you are trying to count the number of [Pay Period Ends] which is less than or equal today, if this is your case please try the following formula:

=IFERROR(COUNTIFS({Payroll Information PP End}, @cell <= TODAY()), "")

and if you like to create formula to count count the number of [Pay Period Ends] which is less than or equal specific day [Current Date] you add it manually if this is your case please try the following formula:

=IFERROR(COUNTIFS({Payroll Information PP End}, @cell <= [Current Date]@row), "")

All comments

Bassam Khalil

Hi @Catly,

as i understand from your formula you are trying to count the number of [Pay Period Ends] which is less than or equal today, if this is your case please try the following formula:

=IFERROR(COUNTIFS({Payroll Information PP End}, @cell <= TODAY()), "")

=IFERROR(COUNTIFS({Payroll Information PP End}, @cell <= [Current Date]@row), "")

Catly

Thank you. You helped me a lot. It worked. Not sure why I was trying to make it so hard.

Bassam Khalil

you are welcome @Catly

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

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.