-
Form Entry cross field validation
Create 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 waiting for an email notification and checking the sheet for conditional formatting. ex. Audit Form is for ensuring batch numbers match from 2 items. If the operator…
-
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