-
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:…
-
Is there a way to utilize one sheet for multiple projects, but still roll up into a dashboard?
I work in an IT department as part of a fairly large school district. We typically don't super fancy PM tools other than a project name, all the tasks associated with that project, who is doing those tasks, and when they need to be completed. So each division in our department has setup their own sheet which as multiple…
-
Formula Help
Hello, I feel like I am close with the current formula I am using in a build out. Could use some help if anyone has suggestions. I have a section where AutoFail is possible and then a Section that is Pass/Fail based on %'s. If they Pass the Pass/Fail Portion but Auto Fail the other portion the entire total score is Auto…
