Is there a way to do this?
I would like my Primary Column (Task Name) to combine it's text with my 'assigned to' column if the condition of the checkbox in column 'Show' is checked.
thanks
Mike
This is doable if you want to set the formula in your primary column and adjust the formula each time you enter it the title of a task.
=IF([Checkbox Column]24 = 1, [Assigned to]24 + " - ", "") + "Task Name"
To set each task name you'd have to come in and edit the formula with your actual task name.
Or you could reverse it...
="Task Name" + IF([Checkbox Column]24 = 1, " - " +[Assigned to]24, "")
Thanks, that will give me something to work with.
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…