-
WorkApps
Tried experimenting with WorkApps this weekend and I am super excited about it, but I do have quite a few questions and blockers at this point, who can I work with to try and get answers or resolution of the issues? I don't want to keep pasting them into new, individual messages and cluttering the community. But I do have…
-
Control Center - Changing Auto-Generated Number
My basic question is if I want to change the auto-generated number on my sheet, do I need to account for the first two blank rows? These are locked rows with formula's. I want to have the first project start with the number 100 instead of 109. Do I start the numbering at 98, so that 100 will be on the first actual project…
-
Control Center - Global Update to add a column forumula
I have an Overdue column (column type is flag) in a project plan/task list. I have a formula that calculates when to set the flag indicating that the task is overdue. With the newly added Column Formula feature, I would like to set the existing formula for the column instead of in each cell. The reason is I have discovered…
-
integration alert to Microsoft Teams
Hi, I'm currently struggling with the integration of Smartsheet to a specific channel in Microsoft Teams. I have built a simple workflow which should alert a Teams channel after a status has changed. Unfortunately, the notifications are not showed in Teams. Automation Permissions are for both the account/sheet-level set on…
-
Jira Connector // Is it possible to sync the flagged status
Hi all, we are using the Jira connector to sync multiple projects from Jira into Smartsheet to make an overall prioritization here. The teams working mostly in Jira are using the flagging function to mark items which need to be discussed in the overall prio meeting. Is it somehow possible to get those marked items from…
-
Overlapping Labels on Bar Charts
I am using a stacked bar graph in order to show a breakdown of projected costs and where they come from. However, when using Data Labels, the totals and highest portion overlap. So far I have not been able to find a way to move labels around at all. I am specifically looking for a way to see the summed totals per month,…
-
Prefix/Suffix Form Names
Hi All, We slap on a generic name for our forms in templates so it's standardized in SCC. However, this opens up a chance to our users when they access a form, say "Daily Report", which then stays in their recently accessed items. In the scenario where a user will access to projects, the forms for both of those will say…
-
Exclude blueprint folder name
Does anyone know what this option on the Naming configuration does? I can't find any specific documentation or examples... Thanks!
-
Is it Possible to (a) Delete and (b) Rename Columns Using Control Center?
Hi, Is it possible to delete and rename columns in a sheet using Control Center? I need to delete a column in a sheet (which was created using a Control Center blueprint) and then push that update out to all projects created using the blueprint. And also the same thing for renaming a column... Thank you, Ron
-
Filters not working with date hierarchy in Power BI
I'm working on a cumulative sales by Dates. To achieve this, I followed below steps - Create Date dimension with calender(startdate,enddate) function Map Date table and Sales table with bidirectional many to one relationship (tried single directional too) Create cumulative sales measure (replace blank sum(sales) with 0 for…