-
If Project name column CONTAINS specific text
Okay I have 2 columns, one contains a unique number (left) and on the right that unique number is listed with the program. I have been able to accomplish this so far, however I ran into a little snag. There are some programs that contain JNEEO, and their unique TDL #. However, once I added the formula I discovered not all…
-
IF(MAX(COLLECT formula issue
Hi, There's an issue in one of my sheets and I can't find what the error is, so I'm hoping somebody can help me please. I have an electric meter submission sheet and a metrics sheet where the data goes into. I have the below formula, which works perfectly for previous months, but 0 value displayed for the month of…
-
Core App Skills Badge not visible
Hi, I took the test and passed but I dont see the badge, where is it?
-
Return multiple values from one search criteria
Hi! I'm fairly new to Smartsheet formulas and have reviewed the community posts trying to find help to my question. I am trying to pull PTO requests from one sheet to another. VLOOKUP has always been a friend, but unfortunately does not pull multiple values. My lookup criteria is a single date, (ex 2/28/24) but there can…
-
Needing to update Summary Sheet mapping
Hello, I am thinking this is an easy question with an easy solution. I have a Control Center blueprint where I have mapped a column incorrectly, Text instead of Contact. The data is coming from the metadata file, which is linked in from the project. Is there an easy way to change the cell linking on the Summary sheet? I…
-
Automation Times
Would highly suggest allowing automations and automatic report emails to be able to send on 15-minute intervals instead of only at the top of an hour. The reports/automations can naturally be slightly delayed, so having them send out 15 minutes prior to a meeting (for example) would be extremely helpful. My team has a lot…
-
Member User ID Modification History Report
My request is simple, provide a report that captures the modifications made to a Member User ID. CreateDate, InitialLogIn, UserTypeModification, Deactivation, Reactivation, Remove ID. A user was most recently experiencing difficulties in access Smartsheet. They had been deactivated, and thus, unable to access SSheet.…
-
Help with formula to count multiple select in one cell
HI! I am hoping to leverage the collective brain power of other smart than myself. I am trying to create a formula via my cross sheet that will count the number of times a contact appears in a cell. What would be even more awesome, would be to count the number of times that an option is within a cell AND the status of that…
-
even better integration with Slack
It's possible in slack to add messages to many 3rd party systems manually. It would be great if there was an option to add messages as rows to smartsheet. Our main tool in our company is Slack where the decissions are made etc. It would be great if we can add important messages to Smartsheet.
-
Organizing Attachments in a Sheet
I was searching for a way to better organize attachments, but could not find a solution. At present I can only sort by name or date and the result is a very flat structure. There appears to be no easy way of grouping documents like a set of folders (document groups) or where I can group documents together in a preferred…
