-
confusing formula results.
I'm working in a smartsheet that combines data from other smartsheets using vlookup formulae. I've written a column formula to add the values in two of these vlookup columns and in some of the cells I get the expected result, and in some I get a #NO MATCH error. I can't figure out what is wrong here. I've reviewed the data…
-
Grouping and summarizing in reports
Is there a way to have two separate groups in reports? Not one "then" another, but two separate ones. I have columns with checkboxes, and I want to group them separately so we can see which rows have "Answered?" checked and which have "Follow-up?" checked, but we don't want it to group in this way because we will have some…
-
Make showing Sheet forms in the navigation pane optional
My team just alerted me to a couple of updates on the web version and that I didn't notice on the desktop version. I feel more comfortable using desktop app. If I may, can you make showing Sheet forms in the navigation pane optional? It's going to cause some confusion. My team tends to create multiple version of the same…
-
Format Parent Rows Only with 'Helper' Columns Not Helping...
Hello, New to Smartsheet and trying to learn! None of the posts on the community have worked but I believe this is a basic question. Using indentation, we're creating parent/child rows for individual projects. I simply want the parent row to be able to highlight a color for that whole row once created to visually separate…
-
Deleting Rows - Any Way to Get them Back?
So I have been deleting rows for project notes and now I am told I should have been moving the rows to a new sheet instead, so the history is there. Is there any way to get the rows back? I can see in the history, but cannot see the rows data in there. Is there another way?
-
"Turn Off" bundling assets when uploading from Smartsheet to Brandfolder
When uploading several assets from a row in Smartsheet into Brandfolder, it automatically "bundles" all of the selected images into one asset with several attachments. While this is a function that may sometimes be convenient, most times it is an inconvenience. It makes it difficult to find the asset we're looking for…
-
Can I turn off "bundling" in Brandfolder when uploading multiple assets from Smartsheet?
I've been testing out the Smartsheet/Brandfolder integration and noticed when I upload to Brandfolder more than one asset at a time from a single row from Smartsheet, it combines/bundles them into one visible asset with multiple attachments. Is there a way to "turn off" that bundling automation? We are uploading multiple…
-
Trouble referencing values in a "CONCATENATE" cell
Hello, I am having issues trying to reference the values in a CONCATENATE formula. I am trying to pull a "Yes" or "No" value based on the product numbers provided in the CONCATENATE cell. The CONCATENATE cell is the combination of product numbers added just for TODAY only (old lines do not show a value unless it is today).…
-
Smartsheet report issue
Hello Everyone, I am observing some strange issues in Reports, so we have this workspace and I have selected the entire workspace, to get the filtered data. I can see most of the sheets but am not able to see a few sheets in my filtered report, on the other hand, my team members who created all the sheets, reports can see…
-
How to select multiple options in dropdown by c# Smartsheet (NuGet 2.126.0 version)
Multiselect dropdown has values - One, Two, Three, Four and we need to select these options by sending values in c# I am using below method to add values cellsToAdd[cellCount] = new Cell.AddCellBuilder(columns[cellCount], true).SetValue(new List<string> { "One", "Two" }).SetStrict(true).Build(); It throws error of unable…