-
Forms: Formatting number field as currency with international currencies included
There is one improvement requested: Formatting the number field in the form as a currency with international currencies included
-
View access to sheets and Dynamic Views without creating Smartsheet account
We would like to share our sheets and/or dynamic views of our sheets with our customers without them needing to log in to view. This should be offered in the same way that Microsoft and Google allow their customers to give view only access with a URL. The Publish option does not work for us because we have set filters that…
-
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
-
Extracting emails from a mixed contacts column
Hello Smartsheet Community, I'm trying to extract email address from contacts column in my smartsheet, but I am unable to do that. i tried using basic string functions funcitons such as find, trim etc to extract the email part between < > but I am encountering errors. can someone help me with a working formula to extract…
-
"Live" source template sheet
We have projects running with long and complex workflows and thousands of tasks - so we need to break these down into multiple sheets (dozens), and then use reports to extract data from tasklits to time-tracking and budget burndown. However - if we need to change the structure or components of the sheet in any way ( extra…
-
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?
-
Formula Help Extracting Month Only from Formula Driven Column
Hi all- I need help trying to extract the month number from another column. My 'Notification Date' column uses a formula (based on the service 'Type') to calculate a specific timeframe. I need to extract only the month from this 'Notification Date' and populate it in the 'Annual Review Month #' column. I was good until I…