-
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
-
Dashboard Template Chart Works - Mine Doesn't with Same Config
I found a dashboard chart on a SmartSheet template that I'm trying to duplicate. I've verified the data in the chart is the same between "My Chart" and the "Template Chart". I've verified the chart config is the same. What the chart shows is different and doesn't seem to reflect my data accurately. What am I missing?
-
Drop Down Columns
Is there something on the Smartsheet Roadmap to be able to select multiple items from a Drop Down column in the similar way we can select multiple contacts in a Contact List column?
-
SSIS package to read Smartsheet data to export the data into SQL database
I need to bring data from Smart sheet data into sql server using ssis. can anyone suggest the steps.