Hey Marquis, do you know how to sync asana task status to worksheet? so I have for example task statusses "todo", "in progress" and "done" as columns in kanban view, and want zapier to fetch those and order in subsheets (worksheets in mastersheet), accordingly. do you know how to do it? do I need to make one zapier for each and every move? or can I automate the syncing through one zap? thanks in advance!
Hey, I’ve never done that myself but it sounds like you’d need to setup a new zap for each of those movements. If you used something like Integromat, you could use if/then logic to do this as well. Hope that helps!
@Marquis Murray, the first 30 seconds you nailed everything I am thinking! Of the dozens of project management systems I've been evaluating, they all have a fatal flaw. That flaw is when I want to create a temporary project without having to manually email out tasks to outside team members, I want those recipients to just open up the sheet of tasks and see if they need to add a document or comment or task update. Everyone requires outside commentors to sign up for an account, even for free, but they must do that. In my profession, real estate, I have a set of tasks for every transaction. I interact with other parties, who are not required to update anything. They are only with the file for 30-60-90 days. A Google Spreadsheet might be a simple way for me to do this, but then why use Asana? Is there a way to share a Google Sheet of tasks to those people so they can edit the Sheet, but not have to get into Asana? I would like them in Asana, but I'd also be fine if they can just edit the Sheet. Big drawback on that: Sheets does not allow attachments as a dropdown in a specific column. So, still not ideal. Do you have any videos that address either of these topics? Thank you!
I’m so sorry for the late response. I can’t believe that I missed this very well thought out question. What changes have you made since posting this comment? I’m asked things like this all the time. Communication with external stakeholders can be tricky if we don’t offer them seats to Asana. Then there’s the topic of training these external stakeholders on how to use Asana. There are cases where a spreadsheet might be best. But understand that Asana is built for collaboration. That should always happen within the tool. I agree that this is a blind shoot for a lot of tools but it’s also a reminder of how true collaboration should work. Let me know what worked for you.
Hi Murray, How can one import tasks with multiple subtasks from csv file to asana? Thanks for your awesome work!
Sadly you cannot. You'd have to convert the tasks to subtasks once the import is complete.
Great Tips to increse productivity ! Thanks for share Marquis
You’re very welcome! Glad you found the video helpful!
Amazing video, massive help! Didnt even know you can do this, who on earth would use a spreadsheet now. Great job Marquis.
Glad you liked it! I ask myself that all the time. 😂
I am going to put all of my spreadsheets in asana cleaning up my drive space love this video great letting us know 👍
That’s awesome! Such a game changer.
Hey Marquis, do you know how to sync asana task status to worksheet? so I have for example task statusses "todo", "in progress" and "done" as columns in kanban view, and want zapier to fetch those and order in subsheets (worksheets in mastersheet), accordingly. do you know how to do it? do I need to make one zapier for each and every move? or can I automate the syncing through one zap? thanks in advance!
Hey, I’ve never done that myself but it sounds like you’d need to setup a new zap for each of those movements. If you used something like Integromat, you could use if/then logic to do this as well. Hope that helps!
Hlw can we suggest a video of complete asana guide from beginner to advance?
Hi there, I have two videos that cover all the basics and advanced of Asana. I'd start there!
@Marquis Murray, the first 30 seconds you nailed everything I am thinking! Of the dozens of project management systems I've been evaluating, they all have a fatal flaw. That flaw is when I want to create a temporary project without having to manually email out tasks to outside team members, I want those recipients to just open up the sheet of tasks and see if they need to add a document or comment or task update. Everyone requires outside commentors to sign up for an account, even for free, but they must do that. In my profession, real estate, I have a set of tasks for every transaction. I interact with other parties, who are not required to update anything. They are only with the file for 30-60-90 days. A Google Spreadsheet might be a simple way for me to do this, but then why use Asana? Is there a way to share a Google Sheet of tasks to those people so they can edit the Sheet, but not have to get into Asana? I would like them in Asana, but I'd also be fine if they can just edit the Sheet. Big drawback on that: Sheets does not allow attachments as a dropdown in a specific column. So, still not ideal. Do you have any videos that address either of these topics? Thank you!
I’m so sorry for the late response. I can’t believe that I missed this very well thought out question. What changes have you made since posting this comment? I’m asked things like this all the time. Communication with external stakeholders can be tricky if we don’t offer them seats to Asana. Then there’s the topic of training these external stakeholders on how to use Asana. There are cases where a spreadsheet might be best. But understand that Asana is built for collaboration. That should always happen within the tool. I agree that this is a blind shoot for a lot of tools but it’s also a reminder of how true collaboration should work. Let me know what worked for you.
your Videos are amazing Bro
Happy to hear that! Thanks for watching
Sussy baka