-
Auto Check a box after 24 hours
I have tried to get smartsheet to auto check a box 24 hours after a row is created and column "Task Started" is not checked. =IF(AND([Task Started]@row <> 1, TODAY() - Created@row >= 1), 1) This returns #UNPARSEABLE. Any help would be appreciated.
-
How to include start/end times (hh:mm) in addition to dates?
I’m building a detailed cutover/go-live schedule and need both date and time (hours:minutes) for each task’s start and end. The standard Date column type only records dates, which isn’t sufficient. I’ve read in a few places that Smartsheet has rolled out a Date/Time column type, but it doesn’t seem to be available in my…
-
Too many years showing
How do I limit the number of years displayed on my Gantt chart? Right now it is defaulting to showing both this fiscal year and next. Isn't there a way to limit the display to JUST this fiscal year? Thanks.
-
Keyboard Shortcuts in TABLE View
Moving from Grid View to TABLE VIEW, we lost keyboard shortcuts such as CTRL+Down arrow which takes you to the lower-most filled cell. Same with CTRL+Shift+Down (or left, right, up, etc). Mimic the keyboard functionality that we have in Excel and in Grid View!
-
Date Column 1 < Gate Column 2 = At Risk
I have a Target Date column and the typical Finish column. I am looking for a formula that will tell me if Target Date is less than Finish Date mark the cell AT RISK. But if the Target Date cell is blank leave it blank. =IF([Target Date]@row > [Finish]@row , "Yes", "AT RISK") I can't get the ISBLANK to work.
-
Metric Sheet - Not updating with Automation Date
Hello everyone, For the past year or two, I've been using automation "Record Date" set to daily as a trigger for the cross sheet references on this metric sheet to update. As of recently, it stopped updating the references despite the automation running and updating the date. Was there a change that broke this? Thank you.
-
Notifications Currently Experiencing Issues?
Hi All, I seem to be having a bunch of notification issues, and I'm wondering if anyone else is experiencing issues. Please keep in mind I have had these automations in place for over 2 years already & they always worked as expected. Is this a system-wide issue, or should I connect with Smartsheet Support? Issue 1 -…
-
Is anyone available to assist me with why I cannot access my Smartsheets
I keep getting an error that I cannot access Smartsheets
-
Add Quick Filters on Column Headers in Reports (like Excel)
It would be very helpful if Smartsheet allowed quick filters directly on column headers, similar to Excel. Right now, creating a filter requires multiple steps and saving it, which takes extra time for simple tasks. Having the ability to quickly filter a column by value, number, or condition (directly from the header…
-
New to SmartSheet - 2 questions on functionality
1: When using a SS form, is there a way to deny a duplicate entry based on an employee name or number? 2. Is there a way to somehow link from SS to Outlook to create calendar invites based on a date field in the SS? Thank you! Kat Gavigan