Auto Fill a row from another row

I am trying to autofill a row with a specific number when a certain drop down in used in another column but I am getting an error. I am not seeing an Automation or a conditional format that supports this so I am assuming that this will require a function but I am not able to figure out which one.

IE- When FY23 is chosen under project name, I want Account Number to auto fill account number 123-456-789 and when FY24 is chosen I want account number to auto fill 987-654-321

Can anyone assist with this one?

Find more posts tagged with

Accepted answers

Ramzi

Try this -

In your Account Number (CPR) field, use this formula:

=IF([Project Name]@row = "FY23", "123-456-789", IF([Project Name]@row = "FY24", "987-654-321",""))

If you have a lot of values, you may want to consider a reference sheet and then INDEX/MATCH into that sheet.

I hope this helps you. Have a great day!

Ramzi

All comments

Ramzi

Try this -

In your Account Number (CPR) field, use this formula:

=IF([Project Name]@row = "FY23", "123-456-789", IF([Project Name]@row = "FY24", "987-654-321",""))

If you have a lot of values, you may want to consider a reference sheet and then INDEX/MATCH into that sheet.

I hope this helps you. Have a great day!

Ramzi

Minni

@Ramzi You are my HERO!!! Thank you so very very much!! It worked!!

Ramzi

Happy to help!

Cheers,

Ramzi

Minni

@Ramzi I had it all set and someone at some point went in and messed it up and now I am having an issue with using multiple IFs in the same cell. Can you assist?

Sign in to join the conversation!

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