-
Returning multiple INDEX/MATCH or COLLECT on separate rows
I have a sheet (call it "Master Sheet") with a column called "Item ID". The "Item ID" is a unique system generated field. This sheet has an other column "Status", Status is a single select drop down column. For sake of argument lets say one of the values is "TRUE". I would like to create a separate sheet (call it…
-
Can I use DataMesh so I can update in either sheet?
I'm very familiar with Smartsheet but far less so with DataMesh so I'm just looking for confirmation on whether what I'm looking for is possible We have 2 sheets, Intake A & Intake B. At a certain point, we copy the row from Intake A to Intake B to create/track a different project. Because of that, Intake B has all the…
-
How do I structure formulas so that I receive a specific count back regarding Task Status?
The Smartsheet above is referenced by multiple members of my organization, but I'd like to simplify some of the information for the members who only want to know specific metrics. I've obscured information that could be considered confidential. I'd like to write formulas that report back the following information: 1. The…
-
Image upload in a form be inserted as an image in a cell in the row
This discussion was created from comments split from: Can an image uploaded in a form be inserted as an image in a cell in the row?.
-
Unix/Epoch Timestamp to DATETIME format?
I'm trying to convert a Epoch Timestamp into a DATETIME format. I've had success using formulas getting it into a date, but am unable to get the time. Anyone have any insight on how to accomplish this? 1517577336206 as a timestamp example which I'd like to convert to 2/2/2018 8:15:36
-
Reminder/Alert Automation
I have this tracking ticket Smartsheet where every 2 weeks, my team of 4 analyst rotate on who's in charge of addressing these tickets. These tickets don't have deadlines, they just have quality information (e.g. ticket name, description, submitter, status, location of issue). I want to create an automated reminder for…
-
Can I share a folder within a workspace to someone without having to share the whole workspace?
Is there a way to share one folder within a workspace with someone, without sharing the whole workspace with them? I want them to see their folder, but not everyone else's folders within the workspace. Is this possible?
-
Issue with Highlighting Columns that have different values
I have a sheet where I am tracking values from one month to the next (values imported using DataShuttle). I want to highlight the columns where the values are different, using a helper column: =IF(Bananas@row = [Previous Bananas]@row, 1, 0) However, I am having the formulas return 0s when the formulas are NOT DIFFERENT.…
-
Changing the UI language > does not seem to work
I would like to turn SmartSheet into english but it keeps on being displayed in french. Changing this parameter as described here does not work: https://help.smartsheet.com/articles/796268-adjusting-personal-settings
-
Cannot type a Name in Contact field of My Smartsheet Contacts
My Smartsheet Contacts, Add, Contact field opens. I go to type Name. Name starts with the letter "J" The letter J does not type into the field. I tried a Bluetooth keyboard and Laptop keyboard, so it is not a keyboard error. This seems like a bug. Any idea how to resolve this? Thank you.
