• Activity
  • Votes
  • Comments
  • New
  • All activity
  • Showing only topics with the tag "excel". Back to normal view
    1. I made a Google Sheets to-do list that self sorts by priority. I hope it helps someone else as much as it's helped me.

      Hey friends, I struggled hard to find a simple to-do list that would work the way I needed it to. Even the paid options weren't quite helpful for me. Eventually I just gave up and made my own. I...

      Hey friends,

      I struggled hard to find a simple to-do list that would work the way I needed it to. Even the paid options weren't quite helpful for me. Eventually I just gave up and made my own.

      I use it at work and at home every single day. I also made a backup copy to handle an individual project I'm working on.

      Anyway, it's free. I just wanted to share it with you guys.

      Small side notes

      • To start using this, just copy it. It'll open in a read-only mode but you can quite easily pull it over to your own Google Drive.

      • I threw in a donation link on the Sheet. Delete it or ignore it. It's 100% optional and I figured I'd put it there in case this ended up becoming someone's daily driver and they want to say thanks.

      • You can somewhat easily make this sheet work with Google appsheet to use it on mobile as an app. That's what I do for mine so that I can use it on my phone and on desktop throughout the day. Just open appsheet from this sheet and start customizing your app. As long as you're using it for just yourself, you don't have to deploy it or anything. You just download the appsheet app on mobile and access it that way. You can even name it and choose a custom icon. The one caveat is that you'll have to create a time trigger in scripts to make it auto sort. If anyone is dying to do this, I'll post more specific details to help you through it.

      https://docs.google.com/spreadsheets/d/1sIp4uPq3xwgudNA9tIOGmNXzETtyG421WbmvJPWgbsI/edit?usp=drivesdk

      17 votes
    2. Help with converting PDF to Excel and back to PDF?

      I may be asking a dumb question or going about this wrong but I'm not sure what to do here. So right now, I receive an estimation from one company in a PDF. It has a bunch of fields such as...

      I may be asking a dumb question or going about this wrong but I'm not sure what to do here.

      So right now, I receive an estimation from one company in a PDF. It has a bunch of fields such as customer name, product, address, etc. Then I type that data and put it into Excel, where I add additional data that I have. From there I have a second PDF which has form fields that I fill with the data of the Excel spreadsheet.

      My problem is with the first PDF that I get from this other company, unless I am doing something wrong I am unable to get that first PDF to show the data as fields. If I convert the first PDF into an Excel then the table data is very messy.

      The amount of typing or copy and paste that it's not hard but it is time consuming. What is the best way for me to go about doing this? I've been Googling things but I'm not sure the right words of action I'm looking for.

      I hope this all makes sense, but if not please ask questions and I'll do my best to try and clarify further.

      12 votes