Auto filling a Formula

I am using a formula to do a COUNTIFS based on Dates, a drop down YES/NO column and a name.

I am wondering if it possible to auto fill the name portion of the formula from another cell.

The formula looks like this:

=COUNTIFS($Date:$Date, <=DATE(2017, 6, 30), $Completed:$Completed, ="Yes", $[Assigned to: Editor]:$[Assigned to: Editor], ="XXXX")

Is it possible to have the information that says "XXXX" in the formula above be auto populated from a name in a cell on that row?

So if I put the name "John Doe" in the cell [Assigned to Editor] row 3, the name "John Doe" replaces the "XXXX"

Find more posts tagged with

Education

Formulas

Support

Project Management

Comments

Andrée Starå

Hi Mark,

Yes, it will work!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mark Case

Thanks Andree,

I have sent an email with a screen shot but will also put it up here.

Basically I am looking at the 2 red squares,

What I want is if I input a name in the Editor column, I need it to put that name into the formula that I shared on the community page of smartsheets,

Thanks for any help you can provide.

Editing 2019 - COPY.jpg

Paul Newcome

Yes. You would just need to add the cell reference.

=COUNTIFS($Date:$Date, <=DATE(2017, 6, 30), $Completed:$Completed, ="Yes", $[Assigned to: Editor]:$[Assigned to: Editor], =[Assigned to: Editor]3)

Andrée Starå

Hi Mark,

I'm glad we got a working solution set up.

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…