-
Multi-Select Count
I have a Smartsheet with a multi-select column. I am trying to determine the formula that will allow me to count how many rows have 1 item selected and how many rows have more than 1 item selected. The specific item is irrelevant. I am just looking for how many equal 1 item selected and how many are greater than 1 item…
-
Automatic Notification in Form Entry
Is there a way to automatically notify an operator as they are updating a form and hit submit that their entries do not match and it's a failed audit other than email notification? ex. Audit is for ensuring batch numbers match from 2 items. If the operator enters a batch that doesn't match, we would like them to be aware…
-
Report format question
I have a report that is Grouped by "Current Task Owner". Why do some of the names show up as Bold and others do not? If I change to no grouping, the names are all bold in the column.
-
Having trouble creating a multiplication formula
I used the AI chat to help create a formula to multiply PPU by STOCK and apply the sum to the entire INVENTORY VALUE $ column. =[PPU] * [STOCK] Why is the sum not populating in the "INVENTORY VALUE $" column? I have the properties set to American $… I think. The AI chat said there may be an issue with the sheet set up This…
-
Counting parent 'in progress' rows
Hi, I'm trying to write a formula to count the number of tasks In progress, where the row level is"0" or "0+" (which are parent rows). Here is my formula: =COUNTIFS({Level}, OR(@cell = "0", @cell ="0+"), {Status}, "In progress") Here's my sheet: I should be getting a total count of 5, but the formula is returning a count…
-
Group Management - Sorting Contact List Alphabetically
Today it appears group lists are sorted by date added (can't really tell)? It is not sorted alphabetically, which would be more helpful.
-
Add Automation Run History Log for Alert, Notification, and Action-Based Workflows
Hi Smartsheet Community! 👋 I'd like to submit a feature request for an Automation Run History or Execution Log for all workflow types — specifically for Alert, Notification, Reminder, Copy Row, and Move Row automations. 🔍 Current Limitation Right now, Smartsheet only provides: A "Last Run" timestamp in Manage Automation…
-
Revert to previous versions of sheets instead of just the activity log snapshot
I just ran automation on an entire sheet instead of just the rows. I wanted to move tasks to a compact task repository, and it moved 364 subtasks that I wish it hadn't. Now, I have to go back and manually revert what I can. Luckily, most of the time, we upload comments and proofs to the parent tasks, which, because they…
-
I cannot access Admin center. Is anyone having this problem?
The page fails to load with message: "Due to network connectivity and feature updates, Smartsheet is experiencing slow loading times". How can I update users another way? I tried to use incognito to open.. same issue. Tried from a friend's PC, same issue. admin
-
Can't find or add a user
Hi, for some reason user rhea.tarin@weststarbank.com is not on the user roles and reports or seat types and true-up lists. We tried to add her using both of her emails and it looks like she was an existing user, and we cannot add her back or find her. Would you please guide us on a solution. Thanks,