-
Re: Is it possible to send reminders to email addresses collected by form submission from non users?
Yes, this is possible. You will just want to be sure the column collecting the email addresses is formatted as a contact column. Additionally, in your workflow settings for the sheet, you'll want to …2 · -
Re: Formula to Summarize spending each week to display in a Dashboard
No worries! I was able to get the following to work predictably: =IF(ISBLANK([Ordered Date]@row), "", IF(WEEKDAY([Ordered Date]@row) = 5, [Ordered Date]@row, IF(WEEKDAY([Ordered Date]@row) …1 · -
Re: April Question of the Month - Join the conversation and receive a badge
All the generalist dabblers over here panicking trying to pick just one thing they would do...Haha! Among other things...I would love to invest in breath-taking real estate, managed in part by an exc…4 · -
Re: Need help dialing in a grading formula [percentage to letter (100 to A+, 80 to B-, etc.)]
Exactly! If any of the results land between grades in decimal places not represented here, the right letter grade may not show. Here's what I would input instead. =IF([Week 04/01 Results]5 > 0.96,…1 · -
Re: COUNTIF & COUNTIFS Formulas
I think you're close but that both need to be COUNTIFS formulas with all your ranges and criteria included. =COUNTIFS({Country or Territory Name}, Label7, {Request Type}, "Outside of the US"…1 ·