Hi Smartsheets community, I have a column of data with cells that contain text values that I need to count. For example, the cell in one of these columns may contain something like: "ABC123 - TEXT TEX…
Hello! Each time I change the sorting of this sheet, my formulas are changed. The formula is technically correct, the issue is that I am referencing exact cells, so when sorting it throws it off. =SUM…
Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:…
Happy faux Friday! I'm working with a very large (about 30 columns) data sheet in Smartsheet. I'd envisioned it as the one source of truth to feed multiple reports. The problem is the latest report I'…
So, I started with =COUNTIF(Name:Name), FIND("John Smith", @cell) > 0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per …
Hi all, I keep running into an issue where I have core sheets in some workflows/dashboards that users keep deleting and I have to go back an restore it. I would love to have the ability as an Admin to…
I could be dreaming but didn't Smartsheet fix the issue where changing a column name breaks reports? Did this get released and then rolled back or am I imagining things?
When I attempt to set a formula in sheet summary the wizard give one option of ‘Refernece another sheet’ and not the sheet you are in. When I click click on the column header in the sheet (i'm in) to …
I have two SmartSheets in use. One for my engineering team, and one for my construction team. I have hundreds of cells linking in and out of both sheets to one another. For some reason the cells which…