-
Formula results varying between today and yesterday
I have a formula pulling info from another sheet. This then feeds into a dashboard metric. The formula is a COUNTIF for anything with today's date. What is happening (and this sounds crazy....I had to get a couple of people to observe it to confirm it wasn't just me) is that at some moments in time the figure on the…
-
Help expediting Data Entry
Greetings, Looking to get some help speeding up our data entry process. We have a note that looks like this: Name: John Doe Phone: 555-555-5555 Email: email@mail.com-and about 15 more fields. These fields need to be taken from the note and manually input in our Smartsheet. I would like to know if it's possible to paste a…
-
Form Entries Lagging
Beginning last week, many users of our forms have experienced severe lagging when typing in text. I've tested it on 3 browsers and there is a definite slow down. I have also noticed a slow down in loading sheets in general. Is anyone else experiencing this? Does the size of a sheet affect the speed of data entry into a…
-
Has anyone had issues with the strategic support team?
In March we were moved off of the customer success team that was supporting us to a "strategic" support team out of the UK. We have people in all time zones in the US using the product with the largest group being out of MST. They are good about accommodating the time zone difference, but since the move, the level of…
-
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!!
-
If, Then Formula
Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover a 45 day period. I added…
-
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…
