-
At location this week, this month
I have created a SmartSheet Travel and Resource calendar where my organization logs in their travel dates, to which operational sites we visit, etc. Each team in the organization has its own sheet, but a dashboard consolidates the information. How can I build a table in the dashboard, that dynamically updates, to show who…
-
Reminder-update request
Hi everyone, I have a formula in my Smartsheet that shows 5 workdays from the submission date. I have an automation setup to send a reminder to the Quality Engineers when a date is reached. Is there a way to be specific, such as when the 5 Day Reminder date is reached, where the condition is that the complaint is open? I…
-
Notification Bell Shows Alerts but No Notifications Appear
Has anyone else encountered an issue with the Smartsheet Notification Center where the red badge on the bell icon doesn’t clear? Mine has been showing “2” unread alerts for several days, but when I click on the bell, the panel says I’m all caught up with no notifications to review. I’ve already checked for update requests,…
-
Summary filed in sheet
Hi Team, I want to display the total amount below into dashboard And I guess I need to use below "sheet summary " , not sure how to get the total amount into the sheet summary Looking for ward to your reply, thanks in advance
-
Why are the Teams workflows inconsistent in how they appear?
The workflow notifications in teams are inconsistent. This is an example of how a message appears if you use "Alert Someone" - "Send to Specific People" and have the Smartsheet app added to your teams account: I want this exact format to appear in a public channel so i change the workflow to be "Send to Microsoft Teams". I…
-
How do I "Ungroup" Automated Alerts
I currently have a couple of alerts set up that once the status is marked Complete, to send an alert, based on certain criteria, to specific email addresses. I'm finding that there may be several rows that have a Status of Complete and qualify to send to the same email address, however, it's not sending an individual alert…
-
I shared my sheets from personal account to my business account and now they won't un-link
Hi, I'm hoping someone has done the same thing and can help me figure out what to do :) When I joined my current company, they did not use SmartSheet. I have my own personal Smartsheet account, that is linked to my email address, and I pay for it annually. I have templates and dashboards created and I started creating some…
-
Force people to change a second cell when they update first cell
Hey Everyone, is there a way to force when they update a cell in one column ( in this case Status), they must also update the Assigned To column before they save?
-
How can I combine grid data and Sheet Summary fields into one editable grid sheet?
I have a Sheet Summary Report that pulls data from 48 individual sheets — this includes both the row-level grid data and each sheet’s Sheet Summary fields. I want to have all of this information (both grid and summary data) together in a regular grid sheet, so I can format it, add formulas, and use it in dashboards more…
-
Forms - Ability to Lock fields
First of all, I use Smartsheet Gov, which I know differs (substantially) from Smartsheet Commercial, as I previously worked with that for about 3 years at my previous company. First Question, for forms, is there a way to LOCK a field? We have a field that comes up auto populated with the TDL #, based on the site where the…
