-
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…
-
Old Notifications
There is an old Notification going out to my Team, I created this a while ago and want to edit it but I can't find it in my Manage Alerts ^ Actions menu. I made note of the Notification ID that is being sent out. Is there any way to search for this Notification by ID? Or how else can I find this notification so I can edit…
-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
-
Gants - Resource allocation, Assigned Groups.
Hey there, new to Smart Sheet and have a question. I'm building gantt charts for some of our projects. I’d like to be able to account for the amount of people that belong to a group/resource to properly scope the amount of time needed for each task. For example, one task within the Gantt would be ‘Fabrication’ – I assign…
-
Dragon Naturally Speaking
Does anyone else use Dragon Naturally Speaking when entering data into Smart Sheets? My expience has been negative. I can go to any other website, and enter text etc. However, SmartSheets does not allow for text to be entered in this matter. I am forced to use dictation box transfers, which is sort of a pain. Thoughts
-
Drag and drop from Google Photos
Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.
-
Workspace Enhancement
Good morning, As our company grows, so does the workspace in smartsheet. Can I add a request to allow notifications from the workspace without having to go into individual sheets to change the automations please. I have about 40 sheets I need to add someone to and have to do this individually through all sheets. Thanks!
-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Sumif Formula
Hi, I'm having problem with my formula below. If I update the column 2 to reference "Amount Invoiced", it automatically change the formula in Column 1 to "AmountInvoiced". I need Column 1 to only reference PO Amount and not Amount Invoiced. See below sample formula that I input on the sheet. Column 1 =SUMIF({FY19 MASTER PO…
-
Is Picklist always Strict through the API?
I'm trying to update cells via the API and one the cells is in a Dropdown list column. However, when the API tries to add a value to the cell. I'm getting a 1042, "The value for cell in column 7098131356849892, beagle, did not conform to the strict requirements for type PICKLIST." However, I've checked the sheet, the value…