Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula Based on Monthly Income

380 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Karim
4 - Data Explorer
4 - Data Explorer

Hi guys,

 

im trying to do an automation that performs the following: 

“If Salesperson A’s monthly revenue is below the target, then do X” 

 

However, I can’t find a way to automatically reflect the revenue of the month based on the month I’m in. I can do Rollup to generate the total revenue,  but not revenue for that specific month. 

How can I solve this? 

1 Reply 1

Hm, if it's just for the month you're in, you could create a new field in the table that checks whether that record's date value is within this month, and use a conditional rollup field on that formula field?