I have created a construction schedule where i have many lines of of tasks that apply in a mixed format to different subcontractors. Each task has it own % value. I have created another sheet where I …
Hi there I am looking for a template to adapt to assist us with machinery maintenance on the farm. I want to be able to record work done and to set reminders for upcoming maintenance tasks. I am sure …
I'd like to be able to create a macro or VBA code that would allow me to create a job folder on our local server using data from my smartsheet. The VBA code in Access looks like this: Private Sub cmdC…
Hello, I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. e.g. | January | 45 | ---------------------…
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent…
OK - I have a sheet that tracks our invoices by VENDOR. We have several vendors in alphabetical order as the "parent" rows and underneath each vendor are their respective invoices (children). The shee…
What am I doing wrong? The formula was fine when I did the tower in air dates from today - 12.31.19, but as soon as I tried to add the condition of lease probability being above 49% it doesn't work. A…
Hi - I am trying to set up an Alert for when a column gets to greater than or equal to .75. When specifying a change, I can only select existing values. When I have typed ">= .75" I have not gotten an…
I know I'm not alone in my dislike for the new "hamburger menu" feature. It has resulted in quite a bit of retraining at our facility, across all 3 shifts, sucking time from my already packed day. The…