-
Outlook Add In not working
I do not recall a Windows update occurring last week, however, this morning when I went to use the Outlook add-in, it is suddenly not working. Non-descriptive message: "Whoops! Our bad, something unexpected happened..." Anyone else running into this all of a sudden, or at some time in the past?
-
Building a report based on the calendar, and I need to use "YESTERDAY"
I'm building a report that will show things that are happening TODAY and in the FUTURE. I can build each of those separately, but together seems to be an issue. I built a filter based upon date being YESTERDAY, but when I go back to check it, it has placed the actual date in the field. Is there a more permanent solution to…
-
count text occurrence in a check box column
I have a multi-user sheet. 4 column with to-do tasks. When tasks are complete, the user put their initials in the box. At the end of the column, I have a formula that adds up the initials and the cell fills in a "YES" for all complete or stays "NO" if not all complete. At any given time, there could be 75-100 of these…
-
Engage Conference on Sep18
Hi, May I ask does anyone join Engage Conference? I know that people can book one-on one design desk (30 minutes). One issue bother me long period of time: How to update existing SmartSheet by Ms Excel. As I open new smartsheet, I usually import Excel. However, after import excel, if there is info change in excel, you need…
-
Notification with attachment
Hi, I have already set up the notification. In my Smartsheet, there are a few columns. One of column is "Mail Out". In this column, pre-set has two answer only: yes , no. In each row, there is an attachment of that specific building word file. So, as I create notification, if mail out column is "yes", email to mail room…
-
IF(AND Today not working correctly. Please help
=IF(AND([Last Contact Date]2 - TODAY() < 90, [Last Contact Date]2 - TODAY() > 120), "3-6 Mths")
-
AppSheet - Get the latest + Engage 2017
Hi there, If you are going to the Smartsheet engage conference, we'd love to meet with you to share the latest from the AppSheet Platform, we'll talk about managing apps and data beyond a 5000 row limitation, and other great features to do even more with apps powered by AppSheet and Smartsheet data. Join us at an informal…
-
(Sumifs, Sumif or If ?)
=IF(AND(([Last Contact Date]3 - TODAY()) > 90, ([Last Contact Date]3 - TODAY()) < 180), "3-6 Mths", IF(AND(([Last Contact Date]3 - TODAY())) > 210, ([Last Contact Date]3 - TODAY() < 365), "7-12 Mths")) Is there also a way to turn a cell, row into a color using functions ? Thanks You
-
Format of rows added thru Webform to Help Desk Ticket Tracker template
I've modified the Help Desk Ticket Tracker template to work with our company. But I have a problem with adding new rows at the bottom of the sheet through the Webform -- it copies the format of the header line "New Form Submissions appear below" instead of the blank line below it. The original template worked correctly,…
-
Highlight Changes with a unique color, shade, or pattern for each user
I would like to submit an enhancement request for the Highlight Changes feature. The tool currently shades cells with a background color if a change has been made in the last seven days. Unfortunately, the same color is used for changes performed by everyone. I'd like to request the ability to customize the background…