-
Asset Tracker via app search function
I am trying to search for a text numerical field i.e. FC090909 The app will find the field if there is a space in the field between the text and numbers i.e. FC 090909 but will not find the whole string if searched together with no space? What am I doing wrong? Thank you
-
Pivot Summary based on base sheet hierarchy
I have a running list of rows (touch points) that have a status associated with them. I want to make some charts that aggregate the responses under the hierarchy. For example, The top level hierarchy is "Quality". The child is "Mock-ups". There are 4 questions related to mock ups, each having a status. I want to chart…
-
Executing a SQL Query?
Is it possible to extract data from two sources (Ultipro and Siteline), store the data in a common repository then query off that repository into Smartsheet? What third party app or apps would we need? Any assistance would be appreciated!
-
Calendar App - Multi-Select Field with Filter
Hello all, I'm looking for a way to be able to utilize a filter on multi-select so that it incorporates the relevant datapoints. However when we do the grouping, it effectively creates grouping by groups and effectively miscategorizes the information. Example: We are using the calendar app for a launch calendar that we…
-
Calendar blocking conditions
Hi! Is there a way to create date block conditions so that in calendar view, a meeting is blocked for that date and also the day after? For example, if someone requests a meeting for September 15 in a form I've created in Smartsheet, I would like the calendar to automatically block off September 15 and September 16. And in…
-
Google Form Sync broke
I had a Google form that was synced with a Smartsheet. I changed the name of the Smartsheet and now the form no longer syncs, even if I put the name back. How do I re-establish the sync?
-
What is the best way to connect "predecessors" in SmartSheets to Jira?
My dev team uses Jira, while the project team wants to use SmartSheets for Gannt charts, dashboards, etc. If we create tasks in Smartsheets through templates, how can we carry over "blocked tasks". In SmartSheets, we refer to it as a predecessor", while in Jira it would be a "linked task" as "blocked by". Any insights are…
-
Font size format does not display in Dynamic View
We have built a training request and tracking system for our employees in Smartsheet. Badges are displayed when an employee completes recommended training milestones. Since I could not discover how to display an image based on formulas, I used the sports medal emoji (🏅) and formatted the font size to 36 pts in the sheet.…
-
Is there a way to put a calendar into a workspace?
How can we organize calendars built with the calendar app into existing workspaces? Thanks!
-
Best practices/overbooking for Smartsheet calendar app?
My company (Bath remodeling company) has our install calendar currently on excel and we do about 22 jobs a day. We are planning to migrate our calendar to Smartsheet calendar app and we are having issues finding a way to provide block outs for some Installers when they request off or how to prevent overbooking. I created a…
