WEEKNUMBER FORMULA

how can i calculate through a formula the availability of a person for the current week considering the range of all the start dates and end dates of the jobs in which he is envolved?

=IF(WEEKNUMBER([Start Date]@row) = WEEKNUMBER(TODAY()), "not available ", IF(WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()), "not available", "available"))

actually i use this formula but the problem is that this formula works just with one start date and one end date, while i have to consider a range of start dates and end dates

thanks

@Andrée Starå

Find more posts tagged with

Accepted answers

All comments

Mike TV

@Filippo01

Try using an =IF(AND( formula. Within the AND you can put multiple logic statement criteria to classify what is needed for a true result.

Filippo01

thanks @Mike TV

are you able to create the formula for me ?

Filippo01

I @Mike TV are you able to write the formula for me ?

Genevieve P.

Hi @Filippo01

I believe I answered your same question in this other post, here:

https://community.smartsheet.com/discussion/94856/formula

If this thread is a different question, we will need to know exactly what it is you're looking for in order to put it together for you. This means it would be helpful to see a screen capture of your sheet and an example output, but please block out sensitive data.

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.