This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello,So currently, we do have a tick box on this view and manually tick it once it is the latest valuation.Do you have any ideas on how can I automate this? without doing the manual ticking?Another issue, I created this formula : IF({latestVal Date}...
Hello, hope someone could help me.So we have this "Status" field.The specific status was "active search"How can I set automation to count how many times that status was moved to active search?Currently, I have this automation set up: The main goal he...
Hello,These presented properties will have a chance to have a different property address linked on this column which is not having any issues.My main question here is there any way how could I set up, the "current property" will be replaced with the...
Hello, I’m currently copying the formula from our excel file to airtable. But some of the formulas are having errors in Airtable.
Can someone help me what are the correct formula of these in Airtable to make it work?
Correct Formula for:
6mo Avg
=ife...
Here's the catch on the bank vals tab = The formula you shared earlier worked it won't add the 0 amounts anymore.When I do the roll-up on the properties it is giving me the highest amount when I do the`MAX(values)`.(which I need)But - on this roll up...
Thank you Adam,It worked! There's only 1 thing remaining.There are 2 same latest valuation dates, which means it will get the amounts of these dates. Is there any way just to get the higher amount?Here's my current setup: Is there any conditions that...
