Tony Fronza
Tony Fronza
Discussions
- Hello! We are trying to create a formula to accommodate the following logic: IF any [RFP Status] of children HAS In Progress or Canceled return the value "In Progress", IF ALL [RFP Status] of children…
- I'm creating a workflow that copies a row from one sheet to another, wherein the sheets are in different workspaces. I saw that you must be an admin or owner on both sheets to do this and I am listed …
- I'm struggling to complete a formula to do the following: If Status is Complete, mark the health green. If Status is Not Started or In Progress and End Date is 10 days or greater, mark health green If…
- I'm working on a formula to reference another sheet, where the other sheet includes various dropdown menu columns. I want the formula to include an IF statement where, when a cell is selected in the s…
- We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Typ…
- Help! I need to finalize a formula to return a value of "Yes" if one of two AND statements are true. I am not getting an error with the formula below, but it is not returning a value of Yes or No: =IF…
- I have a sheet that includes a column of net costs with a Year column. I want to create a sheet summary field with a formula that calculates the total net costs for a specific year (e.g., 2023). I tri…
- I created a formula to populate a field based on the status of various other fields. I got it to work with two conditions (Approved or Declined), but when I add the third (Submitted) with the false re…
- I'm creating sheet summary calculations to tally the total count of a specific dropdown menu item; however, I am using multi-select. I know how to use a standard COUNTIF formula, but it only returns t…
- Hello! I need to create a formula showing the differentials between quarters for two types of data - the total users and total shares for social media posts entered in the sheet. I created fields for …
