I’ve looked through several project management templates, but have not yet seen an approach for tracking or planning hours over multiple weeks or months. It would seem the only way is pivot table like approach where each staff and week is an individu...
Hi, Anyone know if there’s a way to add to or change the ‘average’ function/formula to create a moving average? Thanks, Jeff
If I wanted to show a chart (in a block) of my orders from the last week, is there some way to filter by most recent X days in the chart block? Otherwise, I think I will create a new formula field which would only populate the most recent week with d...
I apologize if this forum isn’t for novice advice I am thinking my ability to clear this hurdle (if it can be cleared) will determine if Airtable is going to be a good choice for me. I manage a grant process. The software that manages my process giv...
Hi (: I’m trying to make a chart with Date as the X Axis, where Date is set via a lookup. It thinks all the dates are 1/1/2018 though so its just showing a vertical line.
Hi! I’m new to Airtables, which I’m going to use as a giant database of my publishing company’s thousands of articles. Before I start defining my tables and entering data, I have a couple of critical questions, and I hope you can help me: I have to o...
I have invoice amounts due by various dates on one table and projected amounts due by various dates on another table. I’d like to combine the two on another table to see projected income. I do not want a sum of the values as I will create a pivot tab...
Hi, I have a linked column and would like to use the selected record in a chart block. I have created a resource plan for my team to show what projects they are planning to work on in the future. The base has a date field, and a number field for the ...
I want to have a simple dashboard record that can summarise information from one (or more) other tables. I want to count the records and total some fields. I have managed to make this work by including a field that I can use the rollup on, but thi...
I have a table that looks like this: 4 Default BFI-1.00-T 5 Default BFI-1.00-P-12 6 Default BFI-1.00-P-12 7 Default BFI-1.00-T 8 Default BFI-1.25-1.00-R 9 Default BFI-1.25-1.00-R 10 Default BFI-1.00-P-12 You can see that there are several ent...
