ContributionsMost RecentMost LikesSolutionsRe: IF Formula HelpAh - that was it! Great call, thank you. I had "Yes" where our formula was testing for "yes". Works perfectly now. Thanks for your help! ------------------------------ Gabriella Tremoglie ------------------------------ Re: IF Formula HelpThanks Mark. Neither of the fields are blank, but this formula is still resulting in blank. If( [Daytime]="no" and [Evening]="no", "no", [Daytime]="yes" or [Evening]="yes", "yes") I should note that both my [daytime] and [evening] fields are already formula-text fields. Not sure if that makes a difference., ------------------------------ Gabriella Tremoglie ------------------------------ IF Formula HelpHello - hoping someone can provide some assistance. I'm trying to create a formula field that gives a Yes/No output based on the answer of two other fields. If [daytime]=no AND [evening]=no, then my [formula field]=no However, if [daytime]=yes OR [evening]=yes, then my [formula field]=yes Does anyone have any ideas? Thank you in advance! ------------------------------ Gabriella Tremoglie ------------------------------ Creating Survey - Rating FieldDoes anyone know of a way to create a field that is rating from 1 to 10 similar to how Quick Base customer care does for their survey (picture below)? I would like to do this for a client survey for our EOTI role. Thank you! ------------------------------ Gabriella Tremoglie ------------------------------ Formula to Show "Day of Week, XX/XX/XXXX to Day of Week, XX/XX/XXXX"Hello, Can someone provide any insight into how to create a formula that produces text that will show [event date start] to [event date end], when [event date end] is empty. I need a field that will combine two date fields to show, for example, "Thursday, May 6, 2021 to Friday, May 7, 2021". I have the following formula in a formula - text field set, but it's showing me what I need in a simple "5/6/2021-5/7/2021" format when I need to spell it out more like above. If(not IsNull([event date end]),ToText([event date start])&"-"&ToText([event date end]),ToText([event date start])) Thank you in advance for your help! ------------------------------ Gabriella Tremoglie ------------------------------