Formula Help

Kelly Cepicky

I need a metric sheet formula that looks into a reference sheet, asks if a field is populated. If it is them populate several fields in the metric sheet. If not do nothing. I can't figure it out. Help please!

Paul Newcome

Have you looked into a row report?

Paul Newcome

Are you able to provide more details and some screenshots for context?

Matt Johnson

Hi @Kelly Cepicky

Try =IF(value you are looking at<>"",value you want to populate, "")

The <> signs together mean IS NOT and the "" or 2 sets of quotes means blank. The first comma sort of means "then" and the second one means "otherwise" in the IF /THEN statement.

I hope that helps.

Matt

Kelly Cepicky

Matt, how do I have it populate several columns if the initial one is not blank?

Kelly Cepicky

Paul, I have several sheets with identical columns but different information in those columns. I'm trying to create a summary metric sheet that looks in those sheets, specifically looks at the "actual start date" to see if it's populated (meaning that it's scheduled for deployment). IF that Actual Start Date is populated then I want it to copy the information from that cell as well as the corresponding team, actual end date, actual FTE savings & Actual $ savings into the metric sheet. I only want to see those lines where there is an Actual Start Date. Make sense?

Paul Newcome

Have you looked into a row report?

Kelly Cepicky

Paul, that actually works!

Kelly Cepicky

Paul Newcome

Happy to help. 👍️