Best Of
Re: February 29th Automations?
Hi @Jack Parry,
It should do - you can see in the calendar for when to start an automation that Feb this year has 29 days but next year only it only has 28.
Need critical chain method
Project managers need the ability to use the critical chain method and fever charts.
Customizable Formatting in Automated Workflow Notification
The ability to customize the automated workflow notifications and incorporate branding into messages would be a great enhancement. The following enhancements would allow our organization to maintain branding within messaging and allow automated notifications to be easier to read and be actionable with customizable formatting.
- Font Capabilities
- Different font options
- Bold, italics, and underlining
- Embedded links
- Color options
Image Capabilities
- Image capabilities
- Banners
- Screenshots
Character Limit Increase
- Currently 2,000
- Need to increase to 2,500/3,000
Alert Someone 4th option
Allow for another option on "Message includes:"
There are currently 3 options for "Message includes:
Links to sheet and all fields
Links to sheet and specific fields
Message only
The Idea, is to add a 4th option: Message and Specific fields.
this will exclude the link to the sheets avoiding confusion from the receiver when they don't have access to a sheet but information from the sheet needs to be shared to them.
Re: Hidden Columns List
For example, in the edit box when you edit a row, add a column with a checkbox where you can hide and unhide any column in the sheet, something like this:
Re: Ignore Blanks When Using Char(10)
@MichaelO1 It would not stop, because they are separate, they are not nested, in this case.
Don't allow editing of workspace permissions when sharing an individual item
Managing sharing at the item level is proving very confusing for people. When trying to share an individual item most users don't realize that they need to leave the Workspace level sharing entry there and add a 2nd entry for item level sharing. Instead, they keep changing the workspace level permission, thinking they they're just changing the item-level permissions.
When viewing the Sharing list for an individual item (sheet, report, dashboard), the workspace permissions either should not be displayed and they should not be editable.
Re: Building a Dashboard from external survey
@alexams In your report you would need to set the filter option to filter the indivdual schools, then in the group option, you would want to group by the Agree/Disagree question and then in the the summary option, summarize the count of the Agree/Disagree question. This will give the report a metric to create against.
Re: Formula to Summarize spending each week to display in a Dashboard
First of all, it looks like your dashboard widget is sorting dates in the same order that your report is set up to sort. You should be able to just sort the dates in the sort tab on your source report.
As for sorting by week, I would suggest setting up a helper column named something like "Week of" with the following formula:
=IF(WEEKDAY([Ordered Date]@row) = 5, [Ordered Date]@row, IF(WEEKDAY([Ordered Date]@row) > 5, [Ordered Date]@row - WEEKDAY([Ordered Date]@row) + 5, [Ordered Date]@row - (WEEKDAY([Ordered Date]@row) + 2)))
This will treat every Thursday as the first day in a week. Then, you can sort your report based on this column, then also being able to summarize by the week cycles you're looking for.
Hope this helps!:)
/users API throwing User not found.
Fetching all users using below API fetches all the users with status, ACTIVE, DECLINED, DEACTIVATED.
https://api.smartsheet.com/2.0/users
But when we try to fetch the single user using https://api.smartsheet.com/2.0/users/abc
If the user abc has status as DECLINED. It fails with error
{
"errorCode": 1020,
"message": "User not found.",
"refId": "la99qz"
}
Any other user with status ACTIVE or DEACTIVATED can be fetched by using the API.
Is this an expected behaviour?