ContributionsMost RecentMost LikesSolutionsColor Cell Formula is not working, any help please?Hello, I'm trying to create a Rich Text Formula fields called "Cell Color for Days Past ISD" that will color the cell "Days Past ISD" which is is a formula - duration field. If the days are under 120, they should remain white. If the days are between 121 and 180, it should be orange. If it is over 180 days, the cell should be red. This is the formula I have written for it: If( [Days Past ISD] > Days(0) and [Days Past ISD] <= Days(120), "0-120", [Days Past ISD] > Days(120) and [Days Past ISD] <= Days(180), "<div style='font-weight: bold; background-color:#ED9121; '>" & "121-180" & "</div>", [Days Past ISD] > Days(180), "<div style='font-weight: bold; background-color:#EE3B3B; '>" & ">180" & "</div>", null ) However, it won't do anything to the field "Days Past ISD", it will only change the color cell of "Cell Color for Days Past ISD". Any help? Thank you! how to add a button in a table to see a reportHello! I'm updating a table, and my team would like to have button that will take them to a report that I've created within the table. They would like to have this shortcut button, either under the filters or next to the "New Project" button. Any help would be great! Thank you!How to add a N/A checkbox for a Date field Hello! I have a table with multiple date fields, but a lot of times my users don't have those dates yet, and I would like them to have the N/A option. Is there a way to add a checkbox next to the date field that says "N/A" and if they click it then the input for the field should be N/A. I don't want this to be a separate field, because I need it to have a N/A input for a monthly report. Any help would be great! Thank you! Re: How to delete total and average rowsGot it! Thank you!Re: How to delete total and average rowsSo are these in the settings for fields? Because I don't see them there.How to delete total and average rowsHello! I'm currently working on a table that shows a bunch of my projects. At the end of the table it shows a TOTAL and AVERAGE row, which I don't want. I've been trying to get rid of it, but I can't find the option to uncheck it any of the settings. Any help? Thank you!Re: If Else Statement to Input in a Yes/No FieldThank you! I'm almost done I swear. No that it works and I have put it as a filter, when I go to the filter itself and it only gives me the option of "<div style='color:green'>No</div>" or "<div style='color:red'>Yes</div>" instead of Yes or No. Any tips?Re: If Else Statement to Input in a Yes/No FieldThank you! However, I forgot to mention that this is a [Days Past Due] is a formula duration field, so it gives me an error that the operator ">=" cannot be use with these types of expressions. Any help?If Else Statement to Input in a Yes/No FieldHello! I am currently working on a field that ask whether or not a project is +140 days over its due date. I have the field "Over +140?" as a Formula - Rich Text. There is another field I am basing it on, "Days Past Due" which gives the actual number of days past due date. I'm hoping to make a if/else statement that will check if the field "Days Past Due" is or over 140, then the field "Over +140" should be populated with the response of "Yes". Otherwise it should be "No". I need this field in order to have it as a filter for my table that will show me all the projects that are 140 and more days past due. Thank you!Re: how to change the color of the field nameOh okay, is this the same case when it comes to form view? Thank you for your help and recommendation.