Formula help

Scotty Andersen

im trying to create a formula that when a date is entered then an amount from another cell is populated basically when task is completed based upon a date entered then this is the revenue

Andrée Starå

Hi @Scotty Andersen

I hope you're well and safe!

Try something like this.

=IF(Date@row <> "", Amount@row)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Scotty Andersen

it gives me a #invalid operation

Andrée Starå

@Scotty Andersen

Ensure that you update, so the column names match yours.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Scotty Andersen

I did here is the formula it is still the same.

=IF({Engineering Tracker Range 1} <> "", [Phase 2 Revenue]@row)

Andrée Starå

@Scotty Andersen

It's because it's on another sheet.

Can you elaborate on how you want it to work?

Also, can you detail the Engineering Tracker Range 1 and what it references?

Scotty Andersen

Awesome thanks that fixed it

Andrée Starå

@Scotty Andersen

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!