Hi, has anyone tested if you have a document template mapped into Document Builder on a sheet template in your blueprint, when you provision a project does the document template get provisioned in the…
Hi, I'm trying to add up all the payments in a column that were made in the last 365 days from the current date. The date the payment was made is in a second column, formatted as a date column. I have…
Hi, I am trying to write a formula that will SUM between one and twenty columns in a row, based on the number in another cell in the same row. If the number is 20, I want to sum all 20 cells in the ro…
Hi, I have the primary data sheet in my blueprint with the Auto Number column type (called "Deal ID") that generates a unique ID for each new row. That ID is used to link other sheets in the blueprint…
I have a sheet where users have to fill in 20 columns with numeric data. In some cases the data will be exactly the same for all 20 columns. In that case, I want to give them the option to select a dr…
Hi, I am looking for help writing a sheet summary formula that will sum all numbers in Column B for all rows matching a criteria in Column A. I have a sheet that tracks transactions by salesperson. Ea…
I want to be able to display the data from a single row on a dashboard (see image), but I want the user to be able to select which row to display from the rows available to them. Can this be done with…
Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard…