Formulas
Discussion List
- I wanted to have a rolling 13 month table that and hoped to have a formula for the first date of the month for 13 months. I have a helper column with today's date in it and have listed the months and …
- I have a sheet that has rows copied from another sheet. Updated versions of the rows are copied over, and I need to remove the old one. I have added two columns, Duplicate and Tag for Deletion. The fo…
- Hello, I have a form for people to submit dinner menus for themselves and for up to 11 guests (but there would be 12 children as the primary contact meal would be a child as well), plus drinks. This f…
- I need to capture the count of tasks starting in the next 7 days that are marked as Not Started. Currently anytime I change the Status to Not Started my formula grabs it. So the task will be in the pa…
- Hi there, I'm trying to use join collect to gather data that has certain info in the "collect" sheet. I have figured out the formula, but i need to put a space between items and i'm not sure how to do…
- Hi SS peeps, I am trying to reference a date in a text column by using the date function but it's not working. =SUMIFS({Employee 1}, {Employee Date of Sep}, >[Jan 5th]45, {Title}, {Lead Sider}) I've t…
- Hi, I'm running into a problem with the column names not being recognized when typing in a formula. I am trying to count the number of users with access using the "yes" symbol and "Active" status usin…
- Hi All, Does anyone know of a formula that can pull the values from an existing column from the week prior using the cell history or activity log? e.g. I can see the value last week in the cell histor…
- Alternate title: Make the most requested calls to an (ideally every) API available as formulas. Often in the community, someone will ask how to do something in a formula. Often, the response is, "You …
- Hello, I am having multiple issues with my calculations using MAX and NETWORKDAYS. In the “Invoice Variance” field my numbers are displaying as negative numbers using the following formula =MAX(NETWOR…
