IF formula with linked columns

Hi everyone,
Now that I have Airtable all up and running with formulas etc. I have hit a snag. I understand we cannot link between bases but we can link within a base.
I’m trying to create a formula that will decrease my stock column by 1 when a NEW appliance is installed into an apartment via the Maintenance tab under the Comments column.

Am I able to do a IF formula in Inventory to read the IF Comment under Maintenance reads NEW - 1 from Stock? I don’t know if the formula will work because the Comment field is typed in.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.