-
Please add a Wildcard Function
Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.
-
Month, Day, Year Date Conversion to MM/DD/YY?
Good afternoon, I'm working with a sheet where the data is imported from Excel, and the Date column is actually the primary column on the Smartsheet tracker. Given that it's the primary, it's obviously not a date column, and since it's imported, it's being imported in this format: March 4, 2024 5:10pm Now, I created a…
-
Setting an entire Project Sheet to On Hold
Hi all, I'm sure someone has encountered this but I'm curious if anyone has done anything with setting an entire project "On Hold" so that it reflects in the rollup sheets/dashboards. For reference, we are using the PMO template to base our projects off of. What we would like to be able to do is put a new row in at the…
-
How do I get my formula to include the leading 0 in the beginning of all numbers?
Currently I am running the formula below to get a set of 8 digits (including a leading 0) to separate it from it from the Site Name. The formula is currently taking the leading 0s out of all of the numbers I am trying to get into my new column, but other than that working fine. How do I get it to include the leading 0 plus…
-
Is there a 'Remove Duplicates' feature?
I am attempting to remove duplicate rows in a sheet but can't find an easy way to do it. I used the AI function to generate a formula for it and I got the above result. Just wondering if there is a feature to remove duplicates or if there may be in the future?
-
Prepopulate Form for Update Request
We use forms to get information from our colleagues and we would want to send them a form prepopulated by their inputs so they can update the information if there are any changes. This would be very useful if we can automate the process and make the items mandatory
-
Expand Count formula (To provide a list of names from another column)
Hi All, This one may not be possible, but will drop it into here to see if it is, thanks in advance for your help. I have a "COUNTIF" Statement in place which is counting the number of times "Red" is listed in a column. In a corresponding column I have a reference to a company name which I would really like to display on a…
-
Change Date based on Symbol
Good day everyone, I've seen a lot of posts about changing a symbol based on the date, but none for the other way around. In my use case, I have a Priority symbol that is being filled in on a form. I need to create a due date based on the Priority chosen and the date the form was entered. I was able to build that initial…
-
Dashboard Chart to Show Rolling 12 Months
I created a sheet that has a primary column for "product type" and additional columns with months listed for the next two years (Dec '20, Jan '21, Feb '21, etc.) which indicates the month in which those products will be implemented. I then have 3 rows for 3 different product types. This data is pulled from a Summary Sheet.…
-
Are you able to pull emails from a Contact column?
I have a few sheets where I am needing to have the data Presented with the individuals name, then the email address in the column next to it. I have come across a few articles that have suggested having a helper 'Contacts Sheet' to reference w/ =INDEX({Contacts Sheet Email}, MATCH{Name@row, {Contacts Sheet Name}, 0)) for…
