Decreasing a set number when a name appears

Hello!

I am trying to create a formula for assignments where I can set a number (3), and when a name appears in a sheet, that number decreases for each time the name appears.

I also currently have a formula where I have the number of times a name appears / 5 (we have 5 days of the week displayed each week so while the person may be assigned to one task, their name appears 5 times, M-F, so I just have the formula divided by 5 days.)

I want to be able to take that number and be able to track if it goes above or below 3. Is this possible?

TYIA!

Find more posts tagged with

Formulas

Automations

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/140101/decreasing-a-set-number-when-a-name-appears

Hi,

I hope you're well and safe!

Try something like this.

=3 - COUNTIFS(Name:Name, "Kaysey")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.