i have 2 sheet
project sheet : projects which include A column = project names and B column = task status
task sheet: A column = task name, B column = project name, C column = task status( True, False)
i used this formula ( if the project Sheet A column = tasks Sheet B column then copy the tasks sheet Column C and paste it in project sheet B column.
i need when i add any more task in tasks sheet and connected to a project and the task status false it have to copy it to the same cell in project sheet as false even if i have 3 task for the same project is true and the 4th is false it have to show false in project sheet
Tasks Sheet A1= fix water pump, B1 = Water Project, C1= True
Tasks Sheet A2= cut water, B2 = Water Project, C2= True
Tasks Sheet A3= buy new pump, B3 = Water Project, C3= False
Then Project Sheet in task status for the Water Project should be False because on of the task is false but if they all was true then the task status should be true
2nd: i need in the tasks sheet C column(task status) to be changed between true and false according to the D Column (task date) if the task date <= today date then C column should be false by default if the task date > today date then task status should be True
26 freelancers are bidding on average $33 for this job
Hi Good Day, I can do this immediate after you accept my bid i am expert in Excel Automation, Data Entry,Internet Research and RPA(Robotic Process Automation).kindly give me this opportunity thank you.
Hello Sir, I read your project carefully .You are searching for Data entry Expert. This is Mehedi Hasan. I am professional Data entry Expert & Digital Marketer. I have huge Experience in this sector. Let’s discuss more
I have gone through the project requirement and interested to work for this project. I want to do it. Please send a message so we can discuss more and start the project. Thanks.