-
Configure "Request to join Smartsheet account" recipients
Currently, when existing contributors within our organization request a full license via the web application, an email is generated and addressed to the SysAdmins within our instance. My preference is that those requests be directed to a single inbox for L1 triage, instead of creating email noise for our IT architects. Is…
-
Formula help - if cell range contain any text, check the checkbox, otherwise uncheck
Hi All, I'm new to Smartsheet and was hoping someone might be able to help. I'm trying to build a formula where if a range of cells with that row contain any text, a checkbox is checked. But if anyone of the cells in that range has not been filled out, the box is not checked.
-
Help getting Index/Match to find search value (number) in a cell with multiple values (numbers)
I have a sheet with the following formula in a column titled "Status": =IF(ISBLANK([PO#]1), "Processing", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range}, 0)) = "Loaded", "OTR", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range}, 0)) = "available load", "Logistics Dept", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range},…
-
Hyperlinks Are Lost When a Sheet is Exported
When I export any of my smartsheets where there is a hyperlink connected to text within a cell, the link is lost. It doesn't matter if it's an excel sheet, google sheet, or PDF, the links are lost and have to be reconnected from scratch. Is there a work around for this?
-
Tracking boxes checked per user per day?
Is there any formula I could use that would track the number of boxes checked by individual users for a specific day? I know I can generate this data in a report, but I'd like to create a formula so I could build around it.
-
Images in Templates
Is it possible to save an image in a template. I have tried but they disappear. I have all options ticked. I understand that I can attach them but visually it would be better for a small image to be shown against the item name. Would this be something that could be done in the future to save having as an attachment and…
-
Can't tab through cells (up, down, left, right) anymore?
Hi, as of a few days ago, I can no longer use my keyboards tab keys to move though smartsheets. This is challenging - does anyone know if there is a setting I can update to restore this functionality?
-
Filter default settings
I use up to 5 sheets at any one time, each containing information relating to different customers. I frequently need to filter information on any particular sub-client via a text/number column. The default ‘Create New Filter’ uses “contains” for me to enter a unique name of the sub-client, and all rows applicable to that…
-
Managing form-generated sheets
Hello: I am new to Smartsheets. We have been using a form-generated Smartsheet to track decisions about new acquisitions. The Smartsheet is getting so many rows on it that it is difficult for staff to use. I'd like to move rejected resources to another tab, and move decisions made more than 2 years ago to another tab. Is…
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…