-
Text String Help... Again!!
Hello All, feel like I am always asking these text string questions but they are so confusing!!! I have a list of retailers and I am trying to just extract the Name of the retailer between either the 1st and 3rd "-" or the 1st and 2nd "-". The problem is with how some of these are formatted like the first one and second…
-
CORS interruption while fetching Smartsheet API
We want to use simple fetch to GET request the data from our Smartsheet instead to the Smartsheet JS SDK. The code snippet is as follows : This JS file has been linked to a HTML file which is being fired up on the browser using Live Server extension available in VsCode. But upon checking the console on the browser (all…
-
What do I do if my automations keep failing?
Good afternoon, We are trying to have data moved from one sheet to another every month using automations but we are running into the issue that once the sheet gets too big (too many rows) the automation will fail to move specific rows out. I am looking for a solution for this issue and an alternative to manually copying…
-
Why am I receiving this error: "calendar.smartsheet.com refused to connect"?
Hello, I am having an issue with embedding a Smartsheet Calendar to Sharepoint. I know it is possible because the exact thing has been done before on our team's Sharepoint. The individual who created the original Smartsheet calendar is no longer with the company. This caused a bunch of access issues leading me to create a…
-
If they can't share = they can't delete rows and comments!
Having better user control over what users can or can't delete in rows and comments is crucial. I suggest that the current user levels be updated as below "Editor Can't Share" should be "Editor Can't Share or Delete" (If they can't share, they also shouldn't have access to Delete rows or Comments). "Editor Can Share"…
-
Filter Not Working in Card View on a Sheet
Hi - My company has a sheet of tasks for employees and it looks like one of the filters isn't working correctly. When Filtered, The All Staff filter has filtered out one person, "Sam the Butcher". I clicked on the drop-down menu and verified that he's the only person filtered out. This is the end of any reference to "Sam…
-
JIra-Smartsheet Connector
Hello All Just trying to figure out it if it is possible to create a Smart sheet workflow from Jira Cloud to smart sheet and within the workflow only connect it to a single ticket or Epic. We do not want it to pull the data in from the entire project. It is a Jira Work Management. Trying to figure out if there is an option…
-
Upcoming Tableau WDC 3.0: Timeline for Smartsheet Connector Update?
Hello Smartsheet Community, I am currently facing a challenge with the upcoming deprecation of Web Data Connector (WDC) 2.0, which impacts our integration of Smartsheet with Tableau. We have been using the Smartsheet-provided WDC available here: https://tableau.smartsheet.com/tableau. As I'm looking for guidance on how…
-
Hello from Biotech
I work in Regulatory Biotech and started using Smartsheet to summarize our Global Submissions data to the Global Health Authorities. Look forward to Smartsheet updating the functionality of charts!
-
Adding Date using 'Today' or 'T'
I just found out that you can use the function 'Today' or just type the letter 'T' in any 'Date field' in smartsheet and it will populate the date. You can also do simple addition or subtraction to calculate for dates. This is on every date field, sheet summary, forms, automation, workflow, rules, send as attachement and…
