-
Mass producing Dashboard with web content widgets
hello everyone, I created a dashboard to act as a huddle board for the business meetings and we will need about 100 different dashboards but dont want an update on one board to impact the other boards. We used web content widgets and when we "save as new" to make a copy - we are having to go in with the unique publishing…
-
Using a formula to count numbers of projects assigned to an employee and at what stage its at.
Hello! I've created a sheet to pull metrics from for some charts I need to make and I'm trying to create a formula that counts the number of projects that are assigned to each employee and its progress level. I more or less understand the first part of the formula counting the assigned projects, but I'm stuck on how to get…
-
Bulk Removal of Users
Hello, Just wanting to check if there's a way of bulk removing of Smartsheet users? I know you can bulk upload contacts/users into Smartsheet but need to know if you can do the same by removing. The reason for this is to avoid a long winded manual audit. In addition, is there a way of linking your Smartsheet account users…
-
JOIN DISTINCT COLLECT or JOIN INDEX COLLECT w/ Multi Dropdown List
Hi, I want to return the "Assigned to" contact for the "Assignee Role(s)" selected in a multi-select dropdown list. Here are the formulas I've tried so far: JOIN(DISTINCT(COLLECT({Project Settings - Team Members}, {Project Settings - Contact Role}, CONTAINS([Assignee Role]@row, @cell))), ", ")) JOIN(INDEX(COLLECT({Project…
-
Find middle number using LEFT and RIGHT Formulas
I have a column with dates that look like this 2022-10-18. I am trying to create a formula using LEFT and RIGHT to only give me the month (in this example = 10) Please help, thanks!
-
Help with #REF
All was good until... Everything was working as designed while setting up PMO template set. Not sure what I did but getting #REF error and would appreciate help in correcting the error . Thank you in advance for your help!
-
Copy row automation/keeping rows linked
Is there a way to keep rows linked from the parent sheet to destination sheet? So if we make changes to the row after the copying takes place to make sure that the destination sheet is also updated with any updates that happen in the row from the parent sheet?
-
Trying to connect Acumatica to Smartsheets
I keep getting an error and cannot find any explaination anywhere. There error says Unable to parse request. The following error occurred: Field "value" was not parsable. value must be a primitive type at [Source: java.io.PushbackInputStream@318c0afb; line: 1, column: 1012]. Could someone explain what I am doing wrong
-
How to list values in a cell based on another cell with distinct names (in a list format too)
Hi, We are trying to present the labor hours workers have dedicated to one same task on different instances. We started by nesting =JOIN(DISTINCT(COLLECT({Worker}, {Task}, "DC6-" + [Task Label]@row), ", "), ", ") We have successfully filtered a list of workers that have dedicated hours to a task. We would then want to…
-
Email Alerts for Multiple Rows, Individually
Is there a way or setting where I can control how email alerts are sent when multiple rows match the criteria? For a while, even if multiple rows matched the criteria, we would always get individual emails/alerts for each row. (i.e. 6 row match criteria = 6 emails). However, after the recent update, I now only get 1 email…