-
Combining SUMIF( and AND( Formulas
I am attempting to sum a large amount of data into totals based on unit, month, general ledger title, so for example: get a total $ amount for Misc Income in the month of July for X Unit. I'm getting an #UNPARSEABLE error. Are there any clear errors here? I cannot figure it out. =SUMIF({CEAS Budget v Actuals Testing Range…
-
Control Center: Adding new sheet template to the existing projects
Hi all, I have tried to add a new template sheet to the existing project in control center, but it seems not functioning. Is there any ways to do it?
-
Does the analyze data chart that is added to the dashboard automatically update?
When using the analyze data and then adding the chart to the dashboard, does the data update when new items are added to the smartsheet?
-
Why is Delete Row Greyed out?
I can delete individual rows, but when I select multiple rows its greyed out. Only when I select 1st - 3rd that it is greyed out. 1st - 3rd row, greyed out 1st - 2nd, OK 3rd - 10th, OK 3rd only, OK 1st - 10th, greyed out This happens randomly. Sometimes its not the 3rd that has an issue, and I'll just select another batch.…
-
Moving/migrating existing SmartSheet data to EU
Is it possible to move the previously stored, existing data to the EU, and changing the current Smartsheet region to EU? In other words, can all data be stored within the EU?
-
Need To Figure out a way or a Formula
How do I split the numbers into the same sheet when they are in a same cell like an array which has been brought to that cell using a formula. Eg: i have 182,183,184…. in one cell and I want to split them and create a row for each number on it's own. How do I do that?
-
Viewing Full Year in Calendar View
I would love to be able to view a full calendar year in calendar view. (We are a school district so I would want it to show July 1, 2025 to June 30, 2026). I create a Professional Learning Calendar every year and would to start using Smartsheet to do this instead of google sheets. I have transferred all of our PL events…
-
Outgoing Notifications Panel
NOTE: Edited by moderator since Enhancement requests are currently supported in English only. My proposal is to develop a new menu or panel within Smartsheet that allows users to view all outgoing notifications generated by sheet automations. The idea is to have a centralized space where users can check the history and…
-
View a Full Calendar Year in Calendar View
I am new to using Calendar View. I have been searching around and messing with it today, hoping to move our district's PL calendar into Smartsheet (I currently build it in google sheets). Is there a way to view a full calendar year in calendar view? (We are a school district so I would want it to show July 1, 2025 to June…
-
Sum based on two columns, words and sum numbers
Hello, I am trying to figure out a formula that will SUMIFS my first range says "Perfect Match 111" and my second range has a number in it. Example if "Perfect Match 111" is in my first range 3 times then I want it to sum the number that is in my second range. So below I would want 6 to come back to my sheet. I have tried…