Is there a way to create a dynamic view/filter where all users assigned to a specific building can see all users within that same building?
Hello, I am trying to count a certain number of product types within a certain work week, both referenced in other sheets. I am able to count my work week data for all product types in one column using =COUNTIFS({Calculation - Defect Rate Run Chart Range 1}, =[Work Week]@row) I have another cell that I am trying to grab…
Hello, I am having issues trying to reference the values in a CONCATENATE formula. I am trying to pull a "Yes" or "No" value based on the product numbers provided in the CONCATENATE cell. The CONCATENATE cell is the combination of product numbers added just for TODAY only (old lines do not show a value unless it is today).…
Link to the sheet: Trying to make a sheet that auto populates a timeline of dates based on two columns that have multiple options. The formula below in the Decal column works if one option is selected, but I need it to work if Bone@row changes from Sternum to one of the other drop down options and also change if the…
Hello Community, We’ve created new content to highlight specific capabilities: DataMesh Learning Track We’ve also created or updated articles in the following areas. Get help AI tool: Find relevant answers with the get help AI tool Time-based one-time passcode (TOTP): Email-based TOTP overview (for System Admins)…
I really want to use the Simple Project Portfolio template but I can't seem to get everything in the "Save as New" folder to do so while keeping all its connections. Maybe I have missed a "how to use" section with this template or just not seeing something obvious any help is greatly appreciated. NOT REQUIRED: I learn best…
Hi all! I have a question about control center. I want to make a global update but it's not possible in a predecessors column. Context: ~1200 projects already provisioned ~500 have data related to the predecessors we don't want to lose So I THINK I can remove the predecessors from the blueprint sheet itself and then…
I have a spreadsheet, which contains a Check Box type column, when it is selected I needed to save the date and time in another column for SLA, I've tried different ways and none of them work, I thought about copying the line and getting it the modified column, but the problem is that it keeps updating, does anyone know…
Help! I have been using smartsheets for 6 years now and have always had a checkbox in two columns. Somehow when I opened my sheet today they are missing for any spots that it has not been checked yet. The boxes dont seem to be hidden as I don't seem to be able to hover over the space and check it off. I have checked the…
