Formulas
Discussion List
- 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…
- Hi I'm setting up a sheet for reoccurring tasks that have different intervals. I have a task column, interval column, last check, next check and a check- box. When the checkbox is ticked the Last chec…
- Hi All, Currently I'm trying to make my RYGB column give the right color light when it meets certain criteria. This must be based on a Start Date column, End Date column and a status column, but I can…
- Apologies in advance, this is a real newbie questions. I am trying to create an IF formula which checks if the value of column Chargeable is TRUE it should then divide the value in Quantity cell by 7 …
- Hi all - I'm trying to find a position of a character within a string, which in theory seems simple - just use the FIND() function. What I'm struggling with is when there are multiple instances of the…
