-
Jira Connector: sync fields that do not exist in all Jira asset types
We use the Jira Connector extensively and find it very useful in enhancing our productivity. One of the limitations we constantly run into it the inability to sync a field that does not exist in all Jira projects returned by our query. For example, we have a Top Level Project in Jira that we use for the highest level of…
-
Pass fail percentage pulled from other sheet
Ok, hi! I was trying to use an old formula and edit it to my needs but it is way too convoluted. Basically i am pulling p, f, and blank from one column in a sheet and want it to give me a percentage of passing on another. This i s even further brokwn down by person (email column) and month (can be date column or month…
-
Consolidate Sheets without Formulas and Functions
Good day, I have 7 sheets that are filled with data and formulas. They are 7 separate sheets because there are so many formulas running that I have maxxed out Smartsheets capability to function on one sheet so I have had to split each sheet by location. How can I consolidate ALL of these sheets into one single sheet…
-
Smartsheet Fields
I am trying to create a smartsheet field to gather the information below: Not sure how to go about it. I would like to select a department and once that department is selected, a column would bring up a list of Equipment assigned to that department in order for employees to check out the equipment. I hope this makes sense?
-
Use API to List All Users, Assume User, and Write Their Workspaces to a Sheet?
This discussion was created from comments split from: API - How can I get all existing workspaces of my organization ?.
-
Proof approval not captured
We are getting email notifications that a proof has been approved, but when going to the proof the status still shows as pending approval. I'm not able to find any pattern or input that is causing it. It also seems to be happening more than usual. Any ideas out there?
-
Form URL based on selection
Hey team, im trying to wrap my head around the file upload limitation on the form. The current limit is 10 files, which is very small. Im thinking of a workaround to send the user to another form after first form is submited for extra uploads. However, I cant figure a way to pass a selection from form #1 to Form #2. On…
-
Quick way to find scheduled send reports from across multiple reports/sheets
Kia ora, Is there a quick way to discover where scheduled send reports, from a report or a sheet, have been set-up, and then modify or delete their occurrence? I have multiple project sheets on the go, and at the close of each I go in and disable all automation workflows, however I don't have capacity (or memory) to check…
-
Can Smartsheet Email Sheet Information to Non-Users?
Is it possible for Smartsheet to email sheet information to someone who doesn’t have a Smartsheet account or access to the sheet?
-
License changes and Google docs integration
Hello! With Smartsheet moving to a subscription model, it sounds like the free accounts will no longer be allowed to populate fields, will need a paid subscription to add data. How will this impact integrations? For example, will users be able to use a google form to fill fields in a smartsheet? Thanks!