-
Modified report based on when comments were added
I am trying to figure out if it is possible to either create a report or even have the modified column updated based on when a comment/attachment was added. Right now, the modified default only updates when someone updates a cell in the row itself. Please let me know if you know a way around this. Thanks!
-
Why is an automated alert no longer working?
Our company has been using Smartsheet for over a year to organize the production process in our shop. Clients submit orders through a form, and when the order is added to the Sheet, we have an automated alert that is triggered to send a copy of the approval to 2 different email addresses. Suddenly one week ago, the…
-
Dashboard Charts Not Updating Automatically
Hi, Issue: Dashboard charts not updating automatically. Source Sheet, Summary Sheet and Dashboard Setup: Source Sheet: List of tasks, has (amongst other columns) [Frequency], [Status], [Due Date] and [Task Due Today] (Formula to determine if the [Due Date] is today's date). Summary Sheet: Uses the Source Sheet as it's…
-
Smartsheet Reports are not getting saved and information is not showing
We are continously facing Smartsheet loading and saving issue. The reports are not reflecting and reports are not getting saved after we fill the details. Our entire organization is stuck at this point. PLEASE LOOK INTO THIS IMMEDIATELY. I have attached the screenshot.
-
Community Badges
Hi Shaine, Is there anywhere that I can view a list of badges and what is required to earn them? It would be great if they had tooltip hovers on them so you could see what they were about without having to go elsewhere. Just a thought . Kind regards, Chris McKay
-
Client name incorrect in Contact List background and will not change
I inherited the Smartsheets/workbooks a couple of years ago, and I recently noticed (on an update workflow request I just created) that a client's name is incorrect. I can not change it. Any ideas where this name is stuck or how I correct it? When I tried to figure out why this happened, I noticed that the name appears…
-
Assistance w/ automated Checkbox based on multiple conditions
Hi All, I'm after some assistance regarding a formula to automate a checkbox based on multiple conditions. These are; Column "Requested by" is populated with a date. Column "Site" is populated. Column "Site contact" is populated. Column "Quantity" is populated. Column "Product" contains the word "Device" Then a sum is used…
-
Notification Automation not working
I have set up a notification automation which would send someone a notification when the status of a deal changes. Attached Screenshots. However, I am unable to get any notification. Do i need to apply a different automation or is my current one missing something? Thanks!
-
Formula for changing drop-down selection in one column when a date is entered in another column
I have a status column with drop-down options (Not Started, In Progress, Complete, N/A). I would like the drop down selection to change to Complete when I enter a date in the Complete Date column. Is this possible?
-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020
I am looking for help creating a formula that works with the above question. I will replicate it for each month through one fiscal year timeline. Currently I have this formula which results in UNPARSEABLE. =COUNTIF({Data Range 3X}, true), COUNTIFS({Tuning Release Date Range}, >= A11, {Tuning Release Date Range}, <= A12) I…