Sign in to join the conversation:
Hello, I have a projects list that allows multiple people to be assigned. What is a formula I can use that will count someone's name when a cell has their name plus other(s)? Thank you in advance.
Formula will be used as a basis for a dashboard
Hi,
Try something like this.
=FIND("Name"; [Assigned To]@row)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Have a fantastic weekend!
Did it work?
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
how to get the formula to get the weighted average of the scrap
I want to set up Smartsheet so that if a request is submitted on the same day and the submission time is between 6:00 PM and 12:00 AM, the Request Submitted Date should automatically move to the next day. For all other cases, it should remain the same day.
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.
