-
Using Microsoft Flow to update an excel sheet when a Smartsheet is updated
I have been searching and trying out with Microsoft Flow to update an excel sheet in SharePoint, when triggered by "When a sheet is updated - Smartsheet". However, no matter how I try, I am not able to get the specific row data values. I could only retrieve information of that sheet, for example modified date or name of…
-
How to send a form triggered by a cell changing?
Hi, I have a Smartsheet that contains information about different pieces of work. Each row is specific to a piece of work and it has multiple columns, one of these is Status. I display this as a Kanban using Card view. When I change the status of an item to Completed, I want to automatically send a form to a contact in one…
-
Auto Alphabetize in a Sheet
Is there a way to have a sheet auto alphabetize? I have a sheet with thousands of rows and users generally enter new rows at the bottom/next available row.
-
Multiple Notifications/Emails for single workflow
I put together a workflow that sends an email for approval, however whenever the project is approved it email blasts the contact who made the request (sends out like 7 emails/notifications) that all say the same thing. Is there a way to only have it send one? What could be causing this?
-
Pull Data for Current Month
We are a construction contractor that uses smartsheet to track all of our projects. I am trying to set up a dashboard to show the current months quotes and current months jobs sold. In the past I have just run a report and then put the date between (1st and last of the month). This gets me the data I am looking for. But I…
-
No longer receiving reminders/notifications
I have not received reminder emails or notifications in the app for any reminders/alerts since 5/22/2019. I have checked my notification settings, my spam folder, I keep running tests, and so far I can't find an easy solution. I've attached screenshots that show my notification center, card view showing active reminders…
-
Locking Details in Calendar App
How can I lock details in the calendar app, so users can't change the data but only view it? Thanks!!
-
Auto-populating dates
I have several categories in my 'Status' column. (Sprint Backlog, Planning, In Progress, In Review, Changes, Print Files Ready, Print Req Sent, With Printing Services, Complete, Blocked) I would like to have a date automatically populate when the Status becomes 'In Review'. Then, once that date is populated, and if the…
-
Email hyperlinks not displaying as typed
Has anyone else experienced trouble with the way email addresses and websites are displayed in cells? Example email address typed into a cell: Support@companyname.com What it changes to when you move to a new cell: <a href="mailto:Support@companyname.com">Support@companyname.com</a> It doesn't happen in all cells, seems to…
-
New User: Form Creation
A new user here. Can someone confirm? Can a FORM be created from an existing sheet, or does the FORM create a sheet, and then additional columns can be added to that sheet?
