Sign in to join the conversation:
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.
Can someone please help on the below formula - it is not working and showing as incorrect argument - I want it to take into consideration both the month and the year - if it past or later than the proposed service date then i want it to show its late via 'YES', blank if its blank and if its in date to show as N/A - the…
I have a Control Center program that creates a project management sheet for each new project. In the Intake Sheet we have a contact column "Project Manager" where Control Center pre-populates the project manager's contact name in every row, of the project, where the project manager oversees the task associated with that…
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…
