-
Latest Comment Column - Default Name Doesn't Include Last Name.
Hi, How can I get the name that appears in the "Latest Comment" column to match the name in the "Assigned To" column? I have a helper "yes or no" column with a formula. The formula is set to enter yes if the latest comment is NOT the person in the "assigned to". Then, I use this helper column for a notification automation.…
-
Can a weekly report not include information from last week?
I have scheduled an attachment to be sent via excel every week to the recipient. It includes information of terminations that need to be made. At the moment, in the sheet there is a checkbox that you tick when you want it to be terminated and a termination date that you include. What I am hoping to do is send a copy of the…
-
Create a way to list local/non-SSO users in admin center
We have SSO setup using Azure AD/Entra ID and were looking for a quick way to find out which users were directly created in Smartsheet. Support told me that there's no way to find that out right now. Please create a way to get a list of non-SSO/local users in the admin center.
-
Include predecessor references with copy to another sheet
Sorry if this is already in the forum. I searched and did not see it submitted as an idea. It only comes up in other discussions. Issue: When using copy to another sheet, the rows do not maintain their predecessor references. Use Case: We utilize Control Center to provision our projects from a standard "PROJECT TEMPLATE".…
-
Link % completion and Status fields
We have 2 columns. 1) % completion 2) Status (not started, in progress, completed, significant delay, etc). We would like that every time we move % Completion from 0 to any number up to 100, Status gets automatically updated to "in progress". And when % completion hits 100%, then Status is "Completed" We will still want to…
-
Creating Dynamic View with Single Value Display in a Multi-Value Column
I have a column that can hold multiple values, but I'm looking to create a dynamic view where only a single value is displayed. While I'm aware that filters can accomplish this, I want the view to exclusively show that specific value. Does anyone have a suggested solution or workaround for this?
-
Is there a way to view the whole workspace activity log?
I am looking for ways to view changes that are being made in a workspace, like track new sheets made, who made them at what time, deleted sheets and dashboards, etc.
-
Admin Roles but Unlicensed
Will each user that I designate as Admin to a workspace/sheet use a license or can they be unlicensed? Do each of the users who submit data through an intake form need an account?
-
Task over due 3 days
How to make it to send an alert when the status is waiting on... and the task due date is over due by 3 days and it alerts the owner. It will only alert On the 3rd day and not all the days between the due date and 3 days past. Then an alert so that it notifies if it is 10 days in the past. The alert will only go out on the…
-
Validation Phone prefix countries missing
When adding a Field in a Form and adding a Validation Phone, there are several missing countries: Croatia, Indonesia, Mauritius, Morocco, Nigeria, Philippines, Serbia, Taiwan, Thailand, Turkey, Vietnam, Uruguay and others. Would it be possible to check and update?