-
My column formula =COUNT(DESCENDANTS()) returns #BLOCKED in one cell. Is there a limit to the count?
All other column formulas work fine. The only reason I can think of is there may be too many descendants? The value returned should be 1540. Is there a limit to the COUNT function?
-
Report Summary - New function isn't working
According to this https://help.smartsheet.com/articles/2482083-summarize-content-to-extract-key-information-with-report-builder I should be able to summarize my report based on ANY field. I am trying to summarize how many tasks an individual person has been assigned to. The help document says that a contact field should be…
-
Has anyone used smart sheet to reconcile general ledger accounts to the subledger?
Wanting to see if we took a report from our purchasing system and uploaded it to a Smartsheet, if it could compare to another sheet that is uploaded from a report from the finance system. I have looked through templates and template sets but not seeing what we are needing. Anyone use Smartsheet to automate the very manual…
-
Hello hello - help with function
this function show all the unique names in one cell =JOIN(DISTINCT(Categories:Categories), " - ") Please i want show the data in different cells thanks ilyas
-
Hello - third time asked for something i didnt get it
the following formulla gave like this =(JOIN(DISTINCT({Task name}))) But the unique names not should in one list like this thanks
-
HELLP PLEASE HELP
I have issues to getting the unique names?
-
Grouping in New Reports
Hi Everyone, The new features in the reports to summarize and group is amazing and has helped us a lot. But I see there no option to group according to "Assigned To" column. Is there any way to do it? I want to analyze performance of individuals over a period of time and I think this feature will help us a lot.
-
Will Dashboard editing every include an 'undo' function?
Hi, it's very frustrating when editing text in a widget, that you can't undo. Hoping this is on a list of improvements. Thanks, Louis
-
Forms- Individual Responses
Hi, Is there a way we can view the submitted individual responses of the forms and in the form format not in a sheet or grid?
-
Sum of Max Value across multiple rows
Hello, I need some help working out a formula that will let me sum the max value across 2 conditions... I have a data sheet that is getting rows copied to is when values are changed on multiple project sheets and i need to have a formula on my report sheet that returns the sum of the highest value in a day for each…
