I have a range of columns with 14 milestones. If the milestone reached, then it will be delete and the cell is blank. Now I would know, in which column are the first date. As result I would need the c…
Hi all-- I am trying to create an efficient way to track my samples as they move around to different facilities. Please see my screenshot for what I am working on. Ideally, I'd like to just have the c…
Hi! My team and I are having a hard time with some of our formulas. We need a count for how many projects that are ending in 30 days and as well as 90 days. Our currently formulas are not providing ac…
Seem to have an issue with the Dashboard I just created not updating appropriately. I have a report reading various project information from a sheet. With said report, I have the condition set to filt…
I'm working on an email campaign and want to see which issue has the highest open rate. If a value in Column C has the highest value in the column, return the value of Column A in the same row. I'm st…
Hi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches…
I have a column set up as "Notes" that I'm using to record all the details of that task. Eg., I'm running a software project so I need more info - it's a new feature, what are the features, what did t…
Hello. Trying to create a new Project-type-sheet with the API, and would like to designate everything about it the way I want in code, so NOT from a template. It appears there is no way to do this wit…
I'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests.…
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to cr…