bisaacs
bisaacs
Reactions
-
Re: IF Function With Multiple Drop Down Selections
Hey @David Bramer, I think you'd want it to look something like this: =IF(OR(EWD@row > TODAY(), [FieldStatus]@row = "Delayed", AND([Field Status]@row = "Not Started", TODAY() &…1 · -
Re: Formula to indicate the duplicate dates
Hey @Jduffy, What do you want the formula to return? Are you wanting to compare the Expiration Date LR and the Expiration Date AER columns for duplicates, or are you looking for duplicate dates in th…1 · -
Re: Values Dropdown List in a form
Hey @Stefano Mauro, Unfortunately you aren't able to do both a user dropdown selection and a formula in the same column. You could have the dropdown list show on the form then hide the on the sheet (…1 · -
Re: Values Dropdown List in a form
Hey @Stefano Mauro, You could use a formula in a Text Column to list an email address based on the dropdown selection. So, in your example, you would put this formula: =IF([Dropdown Column]@row = &qu…1 · -
Re: If Statements
Hey @Whalstead1, IF(AND()) is what you'll want to use: =IF(AND([Column 1]@row = "Yes", [Column 2]@row > TODAY()), "Yes", "No") Hope this helps!1 ·
