-
Row changes that don't affect Modified Date field
I see in your help documentation that changes to discussions and attachments do not affect the Modified Date type of System Column. Is there a reason for this? If a week-long discussion takes place within the discussion feature of a row, the Modified Date element makes it seem at first glance as if the toipic has not been…
-
Pull attachment from Sheet
Is it possible to create a form that pulls attachments and sends back to the requester? e.g., I have a sheet completely filled with a column titled "Common Number Criteria", and an attachment that corresponds to each number in the column. If I created a form and send that link url to an outside user, can they type the…
-
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…