I'm trying to set up an automation in a base that will manage grant application and status reporting deadlines. I want the trigger to be when the field linking to the program is updated to automatically assign the appropriate team members. My setup i...
Hi, I am trying to create a formula that accomplishes the following but am not quite sure how to set it up. Does anyone have any suggestions? IF({FPL %} > 125% but < 300% = "Eligible")Thanks!
I'm looking to create an automation that will find records that match a status at a specified time and create a csv that will then attach to the automated email. Is this possible?I've already used the automation to do this in a grid in the body of an...
I'm trying to build a formula that will look up a currency value from a record, determine whether it is between two ranges of currency, and then enters a percentage (the federal poverty level) in a new column. I'm getting errors in the formula below....
Hi, I’m trying to create an automation to update the status of a record from “scheduled” to “published” when the published date has passed. Does this need to be done using a formula? I can’t find a way to do it with “when a record matches conditions....
@Ben_Young1 I have tried the formula below and am getting an error to check my formula text. It does not give me an option to change formatting at all, unfortunately.IF( AND( {Household number}, {Monthly Income} ), SWITCH( {Ho...
@Ben_Young1 I have one more nuance to this calculation that I'm not sure if I can build into this formula but am hoping you might be able to help. The input form asks the following questions:How many people live in the household? (The options are si...
