Formulas
Discussion List
- Hello! I'm trying to catch if there are any discrepancies between model homes on our manual entry vs the systems data. Model homes should be based on whether ADA is required or not. I've already creat…
- Hello, I am working off the provided personal car mileage tracker to create a monthly total for an employee. I am creating a sheet summary formula. My formula isn't giving me an error but it isn't cal…
- Hello community, I am trying to put together a JOIN COLLECT formula with a criterion whose range is a multi-select dropdown menu. Right now the formula is working when only one is selected from the me…
- Hello! I am going to explain as best I can. So i have a automated system setup and currently i have where they fill out a form and it then auto creates a Fillable PDF. That gets sent to them which the…
- Hello, I am currently using the formula below to get a percentage complete calculation, one of the parameters has the option for NA. How do I include the NA in the formula to make it so it doesn't aff…
- I have many columns and I need to sum the number of blanks within a row. There are a few columns interspersed that are hidden helper columns that should not be included in the count. I have not been a…
- I need to be able to calculate expenses per event and per expense type. I feel silly asking as I should know this but my brain just isn't calculating today. I have tried many variations of the followi…
- I am working on a sheet summary formula. The column in question has a formula that will indicate a task is complete based on other criteria. I am trying to calculate the number of rows that are not re…
- I have a tracker that needs a Status column using Harvey balls. There are columns for 6 mon, 12 mon, and 24 mon MIN and MAX and Completed Visit scheduling dates, and the Project Manager is asking for …
- Is there a way work around to generate one invoice for multiple line (example 10-20 items). I tried document builder but we can be able to generate one invoice in the row level.
