Best Of
Re: Editing Features without a license
@G.Stefania
Update requests.
Integrations
External API
That said this is also dependent on your plan. When you say hold a license could you provide more specifics about if you mean legacy collab or USM? with or without Advanced?
And when you mean hold a license you mean like literally be marked as a licensed user correct?
prime_nathaniel
Re: April Question of the Month - Join the conversation and receive a badge
I do my best to declutter my workspace, but it never stays the way I'd like. The best item on my desk is definitely the switch that raises or lowers the desk's height. I say that because I often forget it's there, but when I do remember and decide to stand up after sitting slouched for what feels like hours, it's more than a stretch; it's a change in my mindset and awareness of how I'm feeling. So here's to anyone else who could pay more attention to that switch on your standing desk!
Holden J
Re: Smartsheet Integration with PowerPoint Office Timeline Pro+ Error
Solution: Add '.smartsheet.com' to your Firewall Allow List.
Leroy Noriega
Re: Invalid Operation Error with Date Range Conditions and Cross Sheet References
You will need an INDEX/COLLECT instead.
=INDEX(COLLECT({Pay Date}, {Begin Date}, @cell <= [Hire/QE Date]@row, {End Date}, @cell >= [Hire/QE Date]@row), 1)
Paul Newcome
Re: Feedback requested: Shape how Smartsheet communicates with other tools!
what I was always missing was a deeper integration with communication tools like #slack
in my previous company #slack was the main tool for everything…
for example we wanted to integrate our ticketing system built in smartsheet with slack so instead of going to the form on Chrome people wanted to typu: /ticketing_system /date /subject…. and so on… but it did not work.
kowal
Re: Workspace Sharing Alert/Notification
Hi @MHalvey
Given that both Smartsheet Bridge and Microsoft Power Automate lack native actions to directly retrieve workspace share information, implementing a solution requires utilizing HTTP requests to interact with Smartsheet's API. Considering ease of development and integration, Power Automate is recommended for this task.
(Bridge)
(Power Automate)
Basic Flow
[Scheduled Trigger] (e.g., every 6 hours)
↓
[GET Workspace Shares via API]
↓
[Compare with Last Saved Record]
↓
[Changes Detected?]
↙ ↘
Yes No
↓ ↓
[Send Notification] [Do Nothing]
↓
[Update Saved Record]
1. Scheduling: Can both Bridge and Power Automate be used for this workflow?
Yes, both Smartsheet Bridge and Power Automate can be configured to monitor workspace sharing permissions by leveraging their scheduling capabilities:
- Power Automate: Utilize the Recurrence trigger to initiate the workflow at specified intervals (e.g., every 6 hours).
- Smartsheet Bridge: Employ the Scheduled Trigger to start workflows on a defined schedule.
However, Power Automate's more intuitive interface and seamless integration with Microsoft services (such as Excel or SharePoint list to store the workspace-share-data) offer a more straightforward development experience for this use case.
2. Developing the Workflow in Bridge: What would it look like?
In Smartsheet Bridge, since there is no native action to retrieve workspace share information, the workflow would involve:
- API Call: Use the Call API module to send a
GETrequest to Smartsheet's API endpoint:https://api.smartsheet.com/2.0/workspaces/{workspaceId}/shares. This requires setting up an API profile with the necessary authentication headers. Smartsheet Help Center - Data Handling: Parse the API response to extract the current sharing information.
- Comparison Logic: To detect changes, compare the retrieved data with previously stored sharing information.
- Notification: If changes are detected, configure actions to send alerts or update relevant records.
- Update Stored Sharing Data: Update row in Smartsheet
While this approach is feasible, it involves a more complex setup than Power Automate.
3. Monitoring Multiple Workspaces: Is a separate flow required for each workspace?
No, it's not necessary to create individual flows for each workspace. In Power Automate, you can:
- Store Workspace IDs: Maintain an array of workspace IDs within the flow.
- Iterate Over Workspaces: Use an Apply to each loop to iterate through the array, performing the share check for each workspace. (In Bridge, you can use the child workflow.)
This approach centralizes the monitoring process, making it more efficient and easier to manage.
Recommended Workflow Using Power Automate:
- Initialize Variables:
- Create an array variable containing the IDs of the workspaces to monitor.
- Scheduled Trigger:
- Set up a Recurrence trigger to run the flow at specified intervals.
- Loop Through Workspaces:
- Use an Apply to each action to iterate over the workspace ID array.
- API Request:
- Within the loop, use the HTTP action to send a
GETrequest tohttps://api.smartsheet.com/2.0/workspaces/{workspaceId}/shares, replacing{workspaceId}with the current ID from the array.
- Within the loop, use the HTTP action to send a
- Compare Data:
- Parse the response and compare it with the previously stored sharing data to identify any changes.
- Conditional Actions:
- If changes are detected, send notifications to relevant stakeholders and update the stored data accordingly.
- Update Stored Sharing Data
Re: Outlook Add-In Stopped working
Wow, I don't know how I missed this. Thank you very much. I am in touch with my IT department to get this working.
Lori Leighton
Re: Dashboard - filter by date and sum?
hi @Hester you cannot add the "Summarise" data from reports to as charts / metrics to your report you can only add the row data from Reports.
If you wanna have metrics with Summarize data I would recommend creting admin sheet that will collect all this data from different sheets etc.
kowal
Re: Help with Automation Workflow based on Large Email List for Condition
Thank you! I was able to use this formula as the solution: =INDEX({Helper Sheet Range 3}, MATCH([Manager Email]@row, {Helper Sheet Range 2}, 0))
b.adams