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
Any one have issues with suddenly not being able to edit formulas? I am admin and owner of the sheet one other admin has access to sheet and no locks have been placed on the cells.
I am trying to find the next upcoming Date and its associated Task based off what activity is being performed and where it's taking place. The formula I have to find the next upcoming date works perfectly: =MIN(COLLECT({Date}, {Date}, >=TODAY(), {Activity}, ="Activity ", {Area}, ="Area")) My problem is trying to get the…
I'm trying to find and number in the Rank column the last two rows that have a status column with a check in the checkbox. I am using the following formula but am getting a #INVALID OPERATION error. =IF(AND(Status@row = 1, [Row #]@row >= LARGE(COLLECT([Row #]:[Row #], Status:Status, 1), 2)), 1, 0) The properties for each…
