Simple request: Can you please incorporate the ability to create colored and/or highlighted fields? I’d like to call out certain rows within sheets. With the inferior, last generation sheets programs (shameless sucking up) I’d always used colors for this purpose. I realize I could use a column for this, but its a waste of a column in my mind, especially if you are trying to avoid scrolling left to right.
I agree with the comments. I simply want to turn a row or cell yellow for someone to look at. I don’t have any conditions that I can program in, I simply want to turn a cell or row yellow.
Looking forward for this to be implemented, but this is a wonderful program!
I too would like to just simply color a cell or column of cells. I get the conditional coloring, but I don’t always need that. Sometimes I just need a very basic highlighting of cells to call attention to something specific or set it apart. Is there a solution for this right now?
I can see it has been stated multiple times, but in the event Airtable needs a certain threshold or number of requests in order to drive a change or update, I’ll back the above. I noticed early in this string @Katherine_Duh mentioned 2 different drivers for color-fill and asks users to specify which they’re seeking since each would represent a different solution on Airtable’s end. It seems both are in-demand and are relatively simple requests considering they’re viewed as basic functionality of this kind of software/service.
My larger need presently is to have the conditional fill. While the conditional insertion of an “emoji” in a cell is a workaround for some people it doesn’t work for our need because when you use the conditional emoji drop in the formula it REMOVES our currency formatting for the rest of the column, which then presents another problem. Using the emoji as a “red flag” for the cell would be fine if it didn’t kill our formatting for the rest of the column. Since it does, having the conditional color-fill again becomes a more viable solution, since it wouldn’t require inserting a character outside those allowed by the “Currency” formatting.
I noticed one person reference the user-expectation that this function like excel, and I second that. Airtable offers a lot of valuable functionality beyond something like excel, but if some of the seemingly basic elements cannot work comparable to competing solutions, it is likely to drive users to go back to using excel for spreadsheet and another competing solution for the rest of the functionality. I’d be curios to learn the issue or problem presented with this case to make the adjustment in Airtable to be more inclusive and user-friendly.
I don’t understand this. A Formula field does not affect other fields content, and you always can add the currency symbol on your own if the result is a combined string and not a number.
I’m not sure I completely understand how you’re referencing the formula and its impact on other fields. At the top of the table, where you input the formula and formatting for any/each given column, it impacts the input (including formatting) for each cell in the entire column (i.e. if you input something in the formula that doesn’t ‘work’ with certain formatting types, it removes the ability to format in that way). When you add the condition for the emoji it removes the ability to use the currency formatting for the entire column, and while we might be able to manually insert a “$” symbol into each cell in the column, that would mean a manual addition to a lot of cells for multiple tables across multiple of our clients. Manually adding that is not really a solution because it would be faster to simply build the same thing from scratch in excel, defeating the purpose. In addition, when the currency formatting is removed, it also removes the 2 numbers past decimal point limit (i.e. $25.xx) so after the formula runs, instead of $25.33 you might get 25.32378128339274. This again just becomes a mess and neither my colleagues nor our clients want to see our primary point of reference reports look like this.
Is anyone working on this? I’d love to be able to change text color as well (for the financials where if it’s negative it would be in red) And I would like to have every other record shaded (gray would be fine) so that it’s easy to read across the grid. We have started to really use airtable for almost all of our forms and we find it difficult to read across for quick checks (verses opening up the record). Just basic stuff I’d think…
