-
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?
-
Matrix Sheet based on date and personal resource assigned
Hello all I'm a bit stumped by this and would like assistance on how to create my formulas. I'm tasked to create a sheet, view, or dashboard to summary our master data sheet turning it into a matrix style sheet. This matrix style sheet will pull data from several other databases within smartsheets. The matrix should…
-
Team Schedule from a form submisson
Hello, I would like to create a form submission for our team of ~45 to input requests for shift times, and days off requests. I want it to encompass the entire month, with the option to select multiple shift times for each day, and multiple days in a week - We currently use an excel doc which looks like this
-
Which formula should i use to tally up the total amount of t-shirt sizes?
Which formula should i use to tally up the total amount of t-shirt sizes? I've tried different variations of sumif and countif but i cant seem to figure it out. For example: My column name is Quantity/sizing with all of these different size quantities: XS - 4 (I want another column with a shirt sizes calculated Total:…
