-
Tracking Time (Tasks)
Greetings, Looking into the prospect of getting my engineers to enter time spent against tasks in addition to 'guessing' and their percentage of completion. It seems the threads here are all a couple years' old or more - wondering if there's any advancements in this arena recently. Regards, jc
-
Budget Sheet YTD Sum formula help
I'm building a sheet for a department who wants to track monthly revenue/expenses and have those numbers roll into YTD columns. (moving them into Smartsheets and out of Excel) Each month has 2 columns Actual & Budget, i want to set up a formula so when numbers are entered into respective monthly cells the YTD cell…
-
Master Schedule
We have a a master sales information sheet that imports from our sales software and then links out to individual client sheets. Each of the the client sheets links to the previous job via cell linking and predecessors, We then have a portal that includes a gantt view of a report that we look at for scheduling - see…
-
Auto Linking Data between sheets
I'm new to smartsheet so sorry for the newbie question. I have a change request log sheet that captures our change request approval process and I would like to "publish" and approved change to a smartsheet calendar. Is there a way to do this? The data I'd like to publish would be a subset of the data in the change request…
-
Linking upcoming dates from sub sheet to the master sheet
My company has a master sheet connected to all the different project sheets. Is it possible to have the next due dates listed in the project sheets automated to update on the master sheet? Currently, we're just doing this manually and it is a pain for us to constantly look at the sheets.
-
"The source data for this chart has changed" - Charts with Zero Values
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
Formula RYG automation with using Complete% and rest of date by end date.
hi I'm trying to create Formula. It's almost completed. However, one last rule doesn't work. Can someone suggest to modify my formula? Currently the following conditions and formula is working fine. - If Complete% is 100% = Green - If Complete% is upper 60% = Green - if Complete% is under 60% and Today is less 5…
-
smartsheet API
Greetings Can someone please explain to me how APIs work ? I am not familiar with many of the technical jargons used on the SMARTSHEET API link. I need to update data on my Gantt charts automaticallu instead of manually inputting the numbers and dates. Can APIs be of any help to carry them out ? Can I somehow read and…
-
API VB EXAMPLES??
Why are there no VB examples shown in your "Smartsheet API 2.0" documentation when you have a VB example by the name of "vb-read-write-sheet"?? It would be VERY helpful if you included VB example code along with all the other languages you provide. Please tell me if you intend to add this?? Thanks David
