-
Publish a shared google Calendar in a sight
Hi there, I've imported our team google calendar into a smartsheet no problem, and I can see all the entries, however when I try to present this in a sight the calendar grid is displayed without any entries. I've 'published' the source sheet with the calendar import, and both the source sheet and sight are shared with all…
-
Automated Update Request rule is in red font
I created an update request to be automatically sent today @ 11AM Central time. The time has come and gone and the request criteria is now in red font. It appears the request was sent, but why is the criteria in red font now? My "Contact" column is a contact list column. All fields are contacts with valid email addresses.
-
Send Update Requests to All Past Due Tasks
I am looking to send a set Update Request to everyone on a project that has an assigned task that shows the Start Date in the past. I further would like it to group all their tasks so they don't get 10 emails if they have 10 past due tasks. Any advice?
-
Report that features tomorrow as due date
Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that. And using "is in the…
-
Help with update requests
Hi all, trying to get my head around automating update requests. I have a large sheet with many columns, each row is a record of an employee, most easily identified by the "email" column which is a type 'contact' and has their valid work email. It also tracks a multitude of events they attended, their reporting manager,…
-
Getting approval notifications to email working
Hello folks, I have created a travel approval workflow whereby once a request for approval is submitted from a form populating a new row in a sheet, it should notify the approver via email. I can't seem to get it to work. The notification comes within the notifications center in the app (desktop and mobile), but the email…
-
Send an Update Request at a Specific Time on a Specific Day
I have read several post regarding the ability to control an update request / timing. I have tried this multiple ways. 1) Created a Form - I struggled with the team picking the correct date (this was necessary). I setup a Outlook Calendar Reminder weekly so it would remind them at a specific time. When they submitted the…
-
Block other users from editing curtain columns
I have a sheet shared with other users, but since the sheet has check Boxes to for approval I want to block other users from editing that column (check box) but still be able to view it.
-
Merge & Center
Hello, The "merge & center" is a formatting option I am quite fond of inside excel and curious if I can replicate this in SmartSheet. I would welcome any feedback. Sincerely, Scott
-
Weekly notifications / update requests delivery settings
Is there a plan to develop a weekly update requests from the Alerts and Actions screen with delivery settings which are the same as the settings defined when applying an update request for individual row or selected rows? It could have a great impact to have the delivery weekly on specific days and not dependent on…