Decreasing a set number when a name appears

Kaysey Lamm

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!

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! 🙏