-
Help with a formula to count how many projects with a brand have the status of "approved"
Hi there, I'm trying to figure out how I can count the number of projects for a brand have a specific status out of the total projects for that brand. Also, I'm referencing a different sheet for these formulas. I already have the formula to count how many projects are associated with a specific brand, but now I want to set…
-
Getting timeout when moving large rows manually to another sheet
Hi there, I have a setup where I have a sheet. I need to import Excel data to this sheet weekly. The sheet and the Excel file have the exact same column names. The data has 145 columns and around 450 rows. Because I can't import directly to the sheet, I tried using copy paste. But, I run into the column limitation that…
-
Suppress "Quick Update" prefix from populating when manually sending row
Is it possible to suppress the "Quick Update:" prefix from populating when manually sending a row? The subject line keys off of the Primary column, which is great because we can codify pieces of row data via formula but we don't want this extra language.
-
Enhancement Request: Workspace / Sheet level Attachments / Discussions
I have submitted this before, not posted to the Community. Still a pain point. I'd like you to revisit the functionality around Attachments and Discussions at the Sheet level and Workspace level. Back in the Good Ol' Days (pre UX update 2018-02-13), we could see that there were Attachments or Discussions at the various…
-
Identifying who is double booked in a meeting at a specific time and date
So I am trying to identify how to see who is duplicated and double booked at specific meeting slots. In the first two rows, you can see the duplicate flag shows up because it is the same exact people in the same order, but when i add "Jordan" on the 3rd row its not showing people are duplicate. Is there a way to show who…
-
Help with a formula
I am trying to use the IF formula and I can't figure out where I am going wrong. Thanks in advance I need to subtract the Contract Amt from the budget amount ONLY if Financial responsibility is TI or Make Ready. So if the financial responsibility says Landlord, I don't want the contract amt to be subtracted from the budget…
-
Formula to bring back value of a cell based on month
Hello! I need help figuring out a formula and possibly on how to set up a helper sheet to get the formula to work: I currently have a capacity plan for our team. My leaders would like a widget on the dashboard that will just show the team members' names and their allocation for the current month. So I need help figured out…
-
how to change a cell value when a new row is added
Hi I am trying to use a workflow that changes the value in a cell when a new row is added. This cell is already on a row in the sheet when the new row is added. I have hit a road block as when I set the trigger for when rows are added it does not change the value in the cell so I am guessing the workflow only runs on that…
-
Customize Option in Row Send?
Hi there! I'm testing out the row send feature. This page says there's a "customize" option, but I don't see it. I see the "layout" option when one row is selecting. What am I missing? At the end of the day, I'd like to know if there's a way to suppress the name of the sheet in the email that sends using this feature.…
-
Adding attachments to a row with 2 forms
Is there any way a row with files in the attachments can be merged with a new form entry that also has an attachment. Currently I am using formulas to join the original row with the new form data but since forms cant add to existing row I cant figure out how to have both attachments on the single row. Is there any way to…
