I'm having a very weird issue. I'm trying to use the Max function to deliver the most recent created date. I have a column type with created date which I have named "created". I've input the following formula =Max(Date:Date) and I keep getting an "invalid column value" error. What am I doing wrong? I would eventually like…
Hi everyone - I finally figured out the weird syntax that sheet summary fields require for sumifs courtesy of an answer to one of the questions for a different user, but I still can't get my formula to work. =SUMIFS([Planned Expense]:[Planned Expense], [Event Type]:[Event Type], @cell = "Moments that Matter", [Event…
Good morning - since there isn't any way to have emails pop up from our enterprise list in a form and there isn't any way to validate emails entered in a form via a formula in another row in our sheet to alert us of any problems - is there any way to access a report and/or see when an automated email message doesn't work?…
I feel ridiculous asking a question when I've seen several others on this same topic and I modeled my formula after them. I'm trying to sum an account total when the string matches either of two different strings and the account code matches a different criterion. I'm just getting an unparseable error so I'm sure it's a…
