Formula Remediation

Ronny Dorian

I asked the AI tool in Smartsheet to help create a formula that achieves the following (the name of the "Engineer" has been changed for discreteness):

i want to create formula that would give [Lead Allocation] * [WIP Revenue] when [Engineer Lead] is "Bob Smith" and otherwise give 0, but I want this formula to sum it up for the entire grid so i could put it in a summary field

Note: Revenue indicates $ amount and Allocation indicates %

I get the following formula, but it is an invalid operation:

=SUMIF([Engineer Lead]:[Engineer Lead], "Bob Smith", [Lead Allocation]:[Lead Allocation] * [WIP Revenue]:[WIP Revenue])

I ask Copilot to remediate it and it gives the following to no avail:

=SUM(COLLECT([Lead Allocation]:[Lead Allocation] * [WIP Revenue]:[WIP Revenue], [Engineer Lead]:[Engineer Lead], "Bob Smith"))

Please help!

Thanks, RD