-
CountIfs for One Date Greater Than Another Within a Given Period
Hi there! I'm trying to get a total of projects projected to start between two dates that actually started after their projected start date. This is the formula that I have so far: =COUNTIFS({Design Document Projected Start Date}, >=DATE(2019, 4, 1), {Design Document Projected Start Date}, <=DATE(2019, 6, 30), {Design…
-
How to print a list of column headings?
Is it possible to print or create a list of just the column headings used in a sheet? And, ideally, include any list (e.g., values listed for dropdown boxes, symbols) associated with each heading? We have a sheet with over 50 columns and would like to find a way to keep track of the headings and their lists. I've checked…
-
Sending approved requests to Outlook Calendar
I am looking at creating a form that will allow my team to submit requests to go into the field for work. This is part of their job and I just need to make sure it is more formally captured with information about where they are going and what they are doing. Can I create a form and then once I approve the request it adds…
-
Date column formatting
Hi! In regional settings, I can change the default date format for a particular region. I'm not able to find anywhere to change the default manually other than creating another column with a formula. For example, I'd like to just have the date show month/day. Is there a place to do that? Thanks, Richard
-
Change in source dashboard template after copying a folder
After using Save as New to copy a folder from one workspace to another, I noticed that a dashboard template in the source folder seemed to have changed in that three recently updated widgets were now indicating "Missing source sheet". There is no indication that this source dashboard template or the related "missing source…
-
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…
-
Report for files not modified in last 45 days?
Is it possible to create a report to list all files (sheets) in a folder not modified in the last 45 days? To be clear: I know how to run a report that shows the ROWS modified within the sheets. I want to know when the SHEETS themselves were last modified. Background: Currently I have a folder with hundred of sheets. They…
-
Not able to moving cards into touch screen monitor.
Hello, I'm using the smartsheet on the touch screen monitor and I have set the appearance as a card view on Gantt charts. With using the mouse I'm able to move cards, But while using the touch on the screen, I'm not able to move them. Please see the attached snap and let me know if there is any solution to resolve it.…
-
Hierarchy in Smartsheet and Jira Connector not working
I don't seem to be able to get any hierarchy to work using the Jira connector. Smartsheet Hierarchy When I first sync'd my smartsheet with Jira all the rows were rearranged and the entire hierarchy in smartsheet was lost. So I figured out I need to use Group by in the Jira connector to respect the Smartsheet hierarchy.…
-
Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v
I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past. For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future. When viewing the report directly, the report is correctly…
