Ramzi
Ramzi
Reactions
-
Re: Count weeks in a Cycle
Here's one way to do it: In this example, I have two columns Cycle Start is a Date column with the date of the start of your 12 week cycle. Week In Cycle gives you the number of weeks into the cycle …2 · -
Re: Showing what quarters students are here from date ranges
Try this: ="Q" + ROUNDUP(MONTH([EXPERIENCE START DATE:]@row) / 3) + IF(ROUNDUP(MONTH([EXPERIENCE START DATE:]@row) / 3) <> ROUNDUP(MONTH([EXPERIENCE END DATE:]@row) / 3), " - Q&q…1 · -
Re: Platform/ account name for autoemails
The email address in From will be the sheet owner. So an option is to use a service account (a company account, not a person) that can own the sheets. I hope that helps.2 ·
