-
Help Article updates
Hello Community, We’ve published the following new content: Smartsheet Control Center: Program reports Admin Center: Configure IdP-managed access Admin Center: Manage IdP role-based groups Prepare your IdP for IdP role-based groups Admin Center: Change a user's primary email address System Admin guide for migration to the…
-
Formula to populate parent row with children row data
I need a formula that will populate a parent row with whichever child row is NOT blank, I would want the parent row to copy the same sentence that is in the child row into the parent row. The reason I need this is because I am using the document builder sheet to create status reports so I need the parent row to pull…
-
Room Reservation System using Dashboard- Calendar, Dynamic View, Form, Report
Hello all, I have seen a number of posts on this subject but none with the most recent updates in Smartsheet. I want to create a booking system that has a root back end grid in which each desk space (70ish distinguised by Room Number and with an added filter of Floor and Direction [2nd floor, 3rd floor West, 3rd floor…
-
Request to Remove Additional Users from Account
Hello, I am facing an issue with my monthly billing over the past two months. I noticed that my bill increased to $120 instead of the usual $72. It seems that additional users were added to my account, even though I did not request this. I have a plan for 3 users only, and I would like to ensure that my subscription is…
-
Group Rows - Parents & Children
Hi everyone, I’m hoping to get some help from the community. Is there a way to automatically group rows in a parent-child format? For example: Parent A Child A Child A Parent B Child B Child B Parent C Child C Child C Each time I add a new row, I’d like it to automatically group based on this logic. If I add a row name…
-
Duplicate Formula
I have a Smartsheet which is fed from a form an Intake team is using to gather prospect information and we are having issues with duplicate entries. The sheet/form has a field for prospect first name and another for prospect last name which we would like to check for duplicate entries of. I created a column combining both…
-
Building out Charts Issue getting an Error
Hello, When I am attempting to build out a Dashboard I am getting the following error when selecting the report… "selected data cannot be charted please select a new range." It won't let me select other data or specific parts either from the report. I have also tried grouping it and no luck. Any recommendations would be…
-
Help Article updates
Hello Community, We’ve published the following new content: File library File library sharing permissions Get started with Smartsheet Pivot App Features of User Subscription Model vs Legacy Collaborator Model Determine the model your plan is on To view the entire catalog of help articles, visit the Help and Learning…
-
Index collect formula question
Hello I need some assistance with my index collect function, In one cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event], [Column23]:[Column23], [Week #]@row, Email:Email, "Person 1"), 1), "") In another cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event],…
-
How to Quickly Count Applications in Use on Smartsheet?
Hello! Could someone help me with a question? Does anyone know how I can quickly get a count of the number of applications in use on Smartsheet? Or do I need to access each sheet one by one and check the logs?
