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…
My sheets have a "header" that serves as a navigation and also serves for the metrics. My problem is that I would like to have the range of a function encompass the entire column (open-end) but i want…
I feel like I'm almost there with this, but just can't figure it out. I'm trying to determine a Sales Rate (money/hours) per Estimator, per month (date range). My column headings are: Ops Start Date, …
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 | ---------------------…
Hello, I have a workspace full of our active projects. Each tasks has a status (not started, in progress, complete) and I would like be able to see the total numbers of these tasks statuses across all…
I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked. Ideally, I would…
Hello, I am new to the Smartsheet world and I just started using this for my projects but I do have a question on how the linking works. I tried linking several project schedules into one integrated p…
I was just made aware that each sheet that is created in Smart Sheets has a 5000 link limit. Is a form that fills a sheet considered a link? If so can a I delete a finished row to provide more room?
This might be incredibly simple but I can't seem to find it already answered! Sometimes when I set a Finish to Start predecessor, the auto-filled "Start Date" is the same date as the predecessor row i…
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…