-
countif and contains statement for extended drop down menu
Hi all, I would like to reach out to the community to help me solve my (probably simple) issue I am facing. To provide you with some context: I am building an online database to enable tracking all the requested amendments and to gain inside into invoicing on a small scale. This database is created for different layers to…
-
New Template Sets for these Workflow Categories! Let me know your thoughts!
Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your organization work remotely more efficiently. Let me know your thoughts, but we are…
-
Hierarchy and Child IDs
Good morning. I have to create 2 forms which will populate parent rows and child rows. I need the parent rows to have a unique quote ID (have this set up now), and child rows to either not have an ID, or have a specific ID that will tie back to the specific quote number. How do I do this?
-
Input the date for a multi-select dropdown
Hi all-- I am trying to create an efficient way to track my samples as they move around to different facilities. Please see my screenshot for what I am working on. Ideally, I'd like to just have the check box as in the screenshot because it's easier and faster. Space on my SmartSheet is also a premium. Now, I'm aware that…
-
Certification Exam
Hi all, I want to take the certification exam for the first time and I wonder if I can retake it anytime without any limitations (I have a smartsheet user of course ), Because there is not a lot of tests out there to practice I think the best way for me is to just try it and i Want to know If I can retake it without any…
-
% Complete Column
Anyone else having issues? I cannot update this column in any of my sheets. It just jumps to the next line of it you hit return it auto adds a full line.
-
Need Help Sorting & Grouping "Day" Data By "Week"
I'm brand new to functions and Smartsheets in general so please bear with me as I attempt to learn with you all. I've read over the functions documentation and to be honest, it's a little over my head. I'm trying to suss out a step by step otherwise I get lost. But I'm hoping I'll get there eventually! Here's the nuts of…
-
Populating a Dropdown List
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
-
Index Match Across Multiple Sheets
Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX({Status},MATCH([Proj ID]@Row,{Proj ID},0)). Each sheet is for a different team,…
-
Trigger Issue
For one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number of approvers is just one. I have a Change Status rule like this: When rows are added…
