-
Renaming Reports - updateReport() functionality
There has been very little discussion on this topic. What is required to get this feature added to the API? I have been assigned the task of creating a JAVA app that will create new workspacea from a set of templates we've created. This is to be done through the JAVA API(SDK). I've completed the app other than renaming the…
-
Email Comparison Formula Needed
Hello Community, I am looking for some help with an email IF Statement and a formula to more information, when a match is detected. I have a couple sets of 3 columns each: Email, First, Last and I need to compare Email with other sets of Emails. NOTE: The 2nd or 3rd or 4th set of Email, First, Last will not have First and…
-
Vlookup limitation of 25000 cells
Can anyone help me to rectify the error as I am using cross sheet vlookup function in Smartsheet to extract some information, while doing this I am facing the error that we can only reference a total of 25000 cells. Is there any way If we want to update multiple columns with the help of other sheet just to avoid the manual…
-
V-axis showing 0 and 1 instead of %
In my chart, I am displaying %, and the chart is showing that in Series -> Data Labels, but the vertical axis is showing only "0" and "1". I would like the vertical axis to show the values given, those between 0 and 1, as a %. Your help is appreciated. Thank you.
-
Webform Submission issue
We are currently using our own custom WebForm to submit directly to Smartsheet. This process has been working flawlessly for the last few months. We had had users reporting now that when they hit submit on our php WebForm the old Smartsheet WebForm pops up and is completely blank. However if we go into Smartsheet, all the…
-
Flag out of Range Date
Hello, I have a date range: Date Range Start & Date Range End, and I want to flag it if the "Actual Completion Date" is before the Date Range Start OR if the "Actual Completion Date" is after the Date Range End. Can anyone help? I've tried: =IF([Actual Completion Date]@row > [Date Range Start]@row, OR([Actual Completion…
-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
Stacked Bar Graph
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
-
Problem sorting report based on "Assigned to" (Contact List)
I am working on producing a report which pulls from a Task sheet (database) based on certain specific tasks and specific statuses. Each task has an "Assigned to" cell which contains a restricted list of contacts (our employees). I have been asked to sort the resulting report by the "Assigned to" column first, and then by…
-
SmartSheet / ServiceNow interface
What is the interface between SmartSheet / ServiceNow and can it be an automated rather than a manual extract which can be extrapolated into reports from Smartsheet?