-
Frozen/Unresponsive Sheets
We're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days. Anyone else experiencing this? Thanks
-
Workaround for Sheet Reference Limit?
Hi everyone, On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel actions organized in rows based on the 50 items. Our goal is to have this sheet…
-
How to create children in large sheet automatically
Hi! I'm new to SmartSheet and not very good with Excel 😪. I have a sheet with over 18,000 rows that I would like to make any cell in the primary column with a date a parent of the rows beneath. I used an excel formula to find and add the date to the Primary column based on blank cells and a separate Event Date column (see…
-
SUMIF Formula Not Working for column with #'s but working with text..
My sumif formula is not working with a numeric value but it is working on a text value.. Here is my formula that is not working: Sheet Referencing: SAP WBSE is the same as Proj. Def. column. I'm asking it to return the Ovr Commit column, essentially 64,345.03 but it's returning 0 but when I sum it on the description column…
-
Filter for contents starting with a 2 or a 6 is no longer working
Searching using Unnamed Filter with "contains" starting with the number 2 or number 6 is no longer is working
-
Copying Attachments Between Sheets
Is there any way to copy attachments between sheets automatically without copying a row? I have a master intake sheet where each row is a different project and attachments can be added. I would like those same attachments to be available in the metadata sheet of the individual project. Basically, the project metadata sheet…
-
#Invalid Data Type with VLOOKUP
Good day everyone, I'm trying to use the formula VLOOKUP to pull some information from another sheets, but it shows me #Invalid Data Type. I have this sheet named "2020 vs 2021 P/Month" and I need the formula to look for revenue on sheet "Rev By Month P/BTC 2020", so when I fill this last one, fills up the information to…
-
Licensed vs Admin status
Does anyone else have a challenge with this mix of functionality? As a "free user" with admin access to a sheet, someone can move or copy entire rows somewhere else. But that same user cannot lock a row or columns. (And, while I am at it, there is no workflow that allows programmatic locking of columns). (This became an…
-
Analyzing Text for Special Characters in a Conditional Formula
I have two sheets. Sheet 1 (Character Table) has a list of non-alphanumeric text symbols (e.g., !, @, #, $, etc.) and alphanumeric characters (A-Z, a-z and 0-9) alongside their ASCII values. This table distinguishes the non-alphanumeric values from the alphanumeric ones by classifying their types as "Special" or…
-
Dashboard Chart Data Selection
When I add a chart to a dashboard, it prompts me to select a sheet, but not the columns to display in the chart. If I try to select data fields of categorical labels and data that are not next to each other, I get an error. How do I select the data to display and can it be summarized? For example, I have a sheet tracking…