-
Smartsheet Groups not showing in Control Center sharing fields
Hi, since yesterday I noticed that when creating a project in Control Center, Smartsheet groups are no more shown as option. Everything worked just fine until yesterday so it seems that there is an issue in Smartsheet, however the status page doesn't show incidens. Is anyone else experiencing the same issue?
-
Predecessors with conditional calculation based on a cell value
Dear all, I need your help to find a way to create a conditional calculation on start days. Fixed values for this: - the project critical date named as "go Live" in "5SS" [Start Date] - always just a 1-day-date value - the date calculation is based on fixed working days, such as 86d or 75d Flexible values: - if in…
-
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…
-
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…
-
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!
-
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…
-
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…
-
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…
-
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…
-
How can I append 2 columns together?
Hi! Just wondering how can I append 2 columns together? I have 4 columns: A, B, C, and D and each of the columns have 1, 2, 3, 4 values, respectively. What I would like to do is create 1 large column containing the values: A1 B1 B2 C1 C2 C3 D1 D2 D3 D4 If this isn't possible, this is what I'm trying to do. I have a 2…