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, "P…
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 …
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 s…
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 multipl…
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…
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 …
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 …
My company is still relatively new to Smartsheet. We have a project template that is working well for us. However, we also would like to also find a way to use Smartsheet to help us plan/schedule our …
Is there a formula or work around to return a dynamic list of unique values from one sheet to another? I'm attempting to create a "Count" of projects by project manager from a project intake sheet. I'…
Hello Community, We’ve published the following new content: Collections in workspaces Learning Track Resource Management in Smartsheet To view the entire catalog of help articles, visit the Help and L…